explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9xUR

Settings
# exclusive inclusive rows x rows loops node
1. 0.305 4.998 ↓ 211.5 423 1

Nested Loop (cost=520.66..1,120.30 rows=2 width=48) (actual time=3.654..4.998 rows=423 loops=1)

2. 0.119 4.210 ↓ 14.6 483 1

Hash Join (cost=520.38..1,086.91 rows=33 width=4) (actual time=3.639..4.210 rows=483 loops=1)

  • Hash Cond: (rco.roadworkcontractownerid = rc.id)
3. 0.596 0.596 ↓ 4.2 1,045 1

Index Only Scan using ix_roadworkcontractowners_isactive_organisationid_roadworkcontr on roadworkcontractowners rco (cost=0.42..563.81 rows=249 width=4) (actual time=0.016..0.596 rows=1,045 loops=1)

  • Index Cond: ((isactive = true) AND (organisationid = 5889))
  • Filter: isactive
  • Heap Fetches: 1045
4. 0.175 3.495 ↑ 1.3 1,236 1

Hash (cost=499.58..499.58 rows=1,630 width=8) (actual time=3.495..3.495 rows=1,236 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
5. 3.320 3.320 ↑ 1.3 1,236 1

Seq Scan on roadworkcontract rc (cost=0.00..499.58 rows=1,630 width=8) (actual time=0.013..3.320 rows=1,236 loops=1)

  • Filter: (isactive AND (validfrom <= now()) AND (validto >= now()))
  • Rows Removed by Filter: 11243
6. 0.483 0.483 ↑ 1.0 1 483

Index Scan using pk_organisation on organisation o (cost=0.28..1.01 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=483)

  • Index Cond: (id = rc.roadworkcontractpublicspacemanagerid)
  • Filter: (isactive AND ispermitmodule)
  • Rows Removed by Filter: 0
Planning time : 3.607 ms