Enterprise Recruitment SystemSpring Boot 4 + Angular 21 + PostgreSQL

Performance Benchmarks

Real-time runs with query plan drill-downs.

Benchmarks Run
9
Live execution snapshot
Success Rate
100%
Completed without errors
Average Duration
32ms
Across all tests

Duration Snapshot

Relative to longest test
Candidate List (Projection)
18ms
Candidate List (Full Entity)
55ms
Contract with EntityGraph
19ms
Salary Events (Partition Pruning)
24ms
Salary Events (No Filter)
128ms
Dashboard (Materialized View)
1ms
Dashboard (Raw Query)
2ms
Count (Estimated)
3ms
Count (Real)
42ms

Latency Trend

Sequence of benchmark runs
FastSlow
Candidate List (Projection)Spring Boot

Uses interface projection - only fetches required columns

Duration 18ms
Records100
Status OK
Candidate List (Full Entity)Spring Boot

Fetches complete entities - more data transferred

Duration 55ms
Records100
Status OK
Contract with EntityGraphSpring Boot

Uses @EntityGraph for eager loading - prevents N+1 queries

Duration 19ms
Records1
Status OK
Salary Events (Partition Pruning)PostgreSQL

Date range query - PostgreSQL skips irrelevant monthly partitions

Duration 24ms
Records100
Status OK
Salary Events (No Filter)PostgreSQL

No date filter - may scan multiple partitions

Duration 128ms
Records100
Status OK
Dashboard (Materialized View)Architecture

Pre-computed aggregations - instant response

Duration 1ms
Records1
Status OK
Dashboard (Raw Query)Architecture

Computed from base tables - multiple COUNT queries

Duration 2ms
Records1
Status OK
Count (Estimated)PostgreSQL

Uses pg_class.reltuples - O(1) complexity

Duration 3ms
Records-1
Status OK
Count (Real)PostgreSQL

Uses COUNT(*) - scans all partitions

Duration 42ms
Records500,000
Status OK