explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l5ro

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 38,204.867 ↓ 0.0 0 1

Nested Loop (cost=70,737.93..112,130.52 rows=9 width=44) (actual time=38,204.867..38,204.867 rows=0 loops=1)

2. 1,228.246 38,204.866 ↓ 0.0 0 1

Hash Right Join (cost=70,737.50..112,103.41 rows=9 width=4) (actual time=38,204.866..38,204.866 rows=0 loops=1)

  • Hash Cond: (cp.roadworkrequestid = roadworkrequest.id)
  • Filter: ((cp.permitid = 131038) OR ((roadworkrequest.permitid = 131038) AND (roadworkrequest.roadworkstatustypeid <> ALL ('{15,3,14}'::integer[])) AND (SubPlan 1)))
  • Rows Removed by Filter: 1161172
3. 9,631.260 9,631.260 ↑ 1.0 1,159,576 1

Seq Scan on combipartners cp (cost=0.00..21,772.76 rows=1,159,576 width=8) (actual time=11.983..9,631.260 rows=1,159,576 loops=1)

4. 412.237 7,964.908 ↓ 1.0 1,095,778 1

Hash (cost=49,558.11..49,558.11 rows=1,095,311 width=28) (actual time=7,964.908..7,964.908 rows=1,095,778 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2322kB
5. 7,552.671 7,552.671 ↓ 1.0 1,095,778 1

Seq Scan on roadworkrequest (cost=0.00..49,558.11 rows=1,095,311 width=28) (actual time=24.947..7,552.671 rows=1,095,778 loops=1)

6.          

SubPlan (forHash Right Join)

7. 19,380.452 19,380.452 ↑ 20.0 1 106,486

Function Scan on getorgtree t (cost=0.25..20.25 rows=20 width=0) (actual time=0.182..0.182 rows=1 loops=106,486)

  • Filter: ((roadworkrequest.roadworkrequestpsmorganisationid = id) OR (roadworkrequest.roadworkrequestpsmcontractororganisationid = id) OR (roadworkrequest.roadworkrequestownerorganisationid = id) OR (roadworkrequest.roadworkrequestownercontractororganisationid = id))
  • Rows Removed by Filter: 2305
8. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_geometryroadworkid on geometryroadwork (cost=0.43..0.50 rows=1 width=60) (never executed)

  • Index Cond: (entityid = roadworkrequest.id)
Planning time : 304.563 ms