explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QGvy

Settings
# exclusive inclusive rows x rows loops node
1. 0.191 4.551 ↓ 211.5 423 1

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

2. 0.114 3.877 ↓ 14.6 483 1

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

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

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

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

  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
5. 3.189 3.189 ↑ 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.189 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 : 1.782 ms