explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pH56

Settings
# exclusive inclusive rows x rows loops node
1. 629.729 1,403.693 ↑ 2.4 625,969 1

Nested Loop (cost=0.58..347,598.62 rows=1,522,646 width=159) (actual time=0.031..1,403.693 rows=625,969 loops=1)

2. 0.056 0.056 ↑ 1.0 34 1

Index Scan using "IX_compliance_process_functional_area_id" on compliance_process cp (cost=0.15..3.01 rows=34 width=4) (actual time=0.011..0.056 rows=34 loops=1)

  • Index Cond: (functional_area_id = 2)
3. 773.908 773.908 ↑ 8.5 18,411 34

Index Scan using "IX_work_compliance_process_id" on work w (cost=0.43..8,661.71 rows=156,169 width=159) (actual time=0.011..22.762 rows=18,411 loops=34)

  • Index Cond: (compliance_process_id = cp.compliance_process_id)