explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HRie

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 905.294 ↑ 2.0 2 1

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

2. 0.514 905.232 ↑ 2.0 2 1

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

  • Join Filter: ((roadworkrequest.roadworkrequestpsmorganisationid = t.id) OR (roadworkrequest.roadworkrequestpsmcontractororganisationid = t.id) OR (roadworkrequest.roadworkrequestownerorganisationid = t.id) OR (roadworkrequest.roadworkrequestownercontractororganisationid = t.id))
  • Rows Removed by Join Filter: 7,132
3. 330.371 900.334 ↑ 2.0 2 1

Hash Right Join (cost=74,134.22..118,042.97 rows=4 width=20) (actual time=770.250..900.334 rows=2 loops=1)

  • Hash Cond: (cp.roadworkrequestid = roadworkrequest.id)
  • Filter: ((cp.permitid = 11,465) OR (roadworkrequest.permitid = 11,465))
  • Rows Removed by Filter: 165,234
4. 184.761 184.761 ↑ 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.040..184.761 rows=1,462,553 loops=1)

5. 31.996 385.202 ↑ 1.0 156,320 1

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

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

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

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

Function Scan on getorgtree t (cost=0.25..10.25 rows=1,000 width=4) (actual time=2.044..2.192 rows=3,567 loops=2)

8. 0.024 0.024 ↑ 2.0 1 2

Index Scan using ix_geometryroadworkid on geometryroadwork (cost=0.43..1.00 rows=2 width=64) (actual time=0.012..0.012 rows=1 loops=2)

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