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
35ms
Across all tests

Duration Snapshot

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

Latency Trend

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

Uses interface projection - only fetches required columns

Duration 25ms
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 18ms
Records1
Status OK
Salary Events (Partition Pruning)PostgreSQL

Date range query - PostgreSQL skips irrelevant monthly partitions

Duration 4ms
Records-
Status OK
Salary Events (No Filter)PostgreSQL

No date filter - may scan multiple partitions

Duration 164ms
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 3ms
Records1
Status OK
Count (Estimated)PostgreSQL

Uses pg_class.reltuples - O(1) complexity

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

Uses COUNT(*) - scans all partitions

Duration 45ms
Records500,000
Status OK