explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JaLh

Settings
# exclusive inclusive rows x rows loops node
1. 437.836 4,463.845 ↑ 15.5 6 1

Unique (cost=26,503.56..26,881.27 rows=93 width=7) (actual time=3,588.635..4,463.845 rows=6 loops=1)

2. 944.404 4,026.009 ↑ 1.1 67,708 1

Sort (cost=26,503.56..26,692.42 rows=75,542 width=7) (actual time=3,588.619..4,026.009 rows=67,708 loops=1)

  • Sort Key: inspections_inspectiontype.code
  • Sort Method: external merge Disk: 952kB
3. 883.894 3,081.605 ↑ 1.1 67,708 1

Hash Join (cost=12,945.01..20,382.78 rows=75,542 width=7) (actual time=1,663.683..3,081.605 rows=67,708 loops=1)

  • Hash Cond: (inspections_booking.inspection_type_id = inspections_inspectiontype.id)
4. 1,339.398 2,170.782 ↑ 1.1 67,708 1

Seq Scan on inspections_booking (cost=12,890.84..19,289.90 rows=75,542 width=4) (actual time=1,636.730..2,170.782 rows=67,708 loops=1)

  • Filter: ((hashed SubPlan 1) OR (book_to_org_id = 252437) OR (book_from_org_id = 252437) OR (executor_id = 252437))
  • Rows Removed by Filter: 15995
5.          

SubPlan (forSeq Scan)

6. 831.384 831.384 ↓ 1.0 114,934 1

Seq Scan on inspections_customorgcontactlocation (cost=0.00..12,604.54 rows=114,521 width=4) (actual time=0.415..831.384 rows=114,934 loops=1)

  • Filter: (org_id = 252437)
  • Rows Removed by Filter: 301909
7. 13.434 26.929 ↑ 1.0 1,741 1

Hash (cost=32.41..32.41 rows=1,741 width=11) (actual time=26.923..26.929 rows=1,741 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 93kB
8. 13.495 13.495 ↑ 1.0 1,741 1

Seq Scan on inspections_inspectiontype (cost=0.00..32.41 rows=1,741 width=11) (actual time=0.327..13.495 rows=1,741 loops=1)

Planning time : 12.903 ms