explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OOnE

Settings
# exclusive inclusive rows x rows loops node
1. 0.275 4.980 ↓ 211.5 423 1

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

2. 0.123 4.222 ↓ 14.6 483 1

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

  • Hash Cond: (rco.roadworkcontractownerid = rc.id)
3. 0.593 0.593 ↓ 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.019..0.593 rows=1,045 loops=1)

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

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

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

Seq Scan on roadworkcontract rc (cost=0.00..499.58 rows=1,630 width=8) (actual time=0.016..3.368 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 : 2.630 ms