explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gnxv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 920.721 ↓ 0.0 0 1

Nested Loop (cost=74,134.90..118,078.53 rows=4 width=44) (actual time=920.721..920.721 rows=0 loops=1)

2. 0.000 920.721 ↓ 0.0 0 1

Nested Loop Semi Join (cost=74,134.47..118,074.43 rows=4 width=4) (actual time=920.721..920.721 rows=0 loops=1)

  • Join Filter: ((roadworkrequest.roadworkrequestpsmorganisationid = t.id) OR (roadworkrequest.roadworkrequestpsmcontractororganisationid = t.id) OR (roadworkrequest.roadworkrequestownerorganisationid = t.id) OR (roadworkrequest.roadworkrequestownercontractororganisationid = t.id))
3. 334.952 920.721 ↓ 0.0 0 1

Hash Right Join (cost=74,134.22..118,042.97 rows=4 width=20) (actual time=920.720..920.721 rows=0 loops=1)

  • Hash Cond: (cp.roadworkrequestid = roadworkrequest.id)
  • Filter: ((cp.permitid = 242,045) OR (roadworkrequest.permitid = 242,045))
  • Rows Removed by Filter: 165,236
4. 182.917 182.917 ↑ 1.0 1,462,553 1

Seq Scan on combipartners cp (cost=0.00..27,708.53 rows=1,462,553 width=8) (actual time=0.032..182.917 rows=1,462,553 loops=1)

5. 34.550 402.852 ↑ 1.0 156,320 1

Hash (cost=71,211.10..71,211.10 rows=159,209 width=24) (actual time=402.852..402.852 rows=156,320 loops=1)

  • Buckets: 65,536 Batches: 4 Memory Usage: 2,389kB
6. 368.302 368.302 ↑ 1.0 156,320 1

Seq Scan on roadworkrequest (cost=0.00..71,211.10 rows=159,209 width=24) (actual time=0.065..368.302 rows=156,320 loops=1)

  • Filter: (roadworkstatustypeid <> ALL ('{15,3,14}'::integer[]))
  • Rows Removed by Filter: 1,220,299
7. 0.000 0.000 ↓ 0.0 0

Function Scan on getorgtree t (cost=0.25..10.25 rows=1,000 width=4) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_geometryroadworkid on geometryroadwork (cost=0.43..1.00 rows=2 width=64) (never executed)

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