explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dTjW

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

Nested Loop (cost=1,713.43..8,078.22 rows=6,765 width=8) (actual time=0.011..0.011 rows=0 loops=1)

2. 0.011 0.011 ↓ 0.0 0 1

Index Scan using pk_organisation on organisation org (cost=0.28..8.30 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id = 26)
  • Filter: iscombicoordinator
  • Rows Removed by Filter: 1
3. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,713.15..8,002.27 rows=6,765 width=8) (never executed)

  • Hash Cond: (p3.permitpublicspacemanagerid = c.roadworkcontractpublicspacemanagerid)
4. 0.000 0.000 ↓ 0.0 0

Gather (cost=1,020.74..7,140.30 rows=1,941 width=8) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
5. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=20.74..5,946.20 rows=809 width=8) (never executed)

  • Hash Cond: (p3.permitownerorganisationid = o.id)
6. 0.000 0.000 ↓ 0.0 0

Parallel Index Only Scan using ix_permit_owner on permit p3 (cost=0.42..5,120.37 rows=63,810 width=12) (never executed)

  • Index Cond: (permitforcombi = false)
  • Filter: (NOT permitforcombi)
  • Heap Fetches: 0
7. 0.000 0.000 ↓ 0.0 0

Hash (cost=19.29..19.29 rows=82 width=4) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_organisation_iscombipartner on organisation o (cost=0.28..19.29 rows=82 width=4) (never executed)

  • Index Cond: (iscombipartner = true)
  • Filter: iscombipartner
9. 0.000 0.000 ↓ 0.0 0

Hash (cost=659.47..659.47 rows=2,635 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=500.04..659.47 rows=2,635 width=8) (never executed)

  • Hash Cond: (co.roadworkcontractownerid = c.id)
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ix_roadworkcontractowners_isactive_organisationid_roadworkcontr on roadworkcontractowners co (cost=0.42..118.29 rows=3,293 width=8) (never executed)

  • Index Cond: ((isactive = true) AND (organisationid = 26))
  • Filter: isactive
  • Heap Fetches: 0
12. 0.000 0.000 ↓ 0.0 0

Hash (cost=374.79..374.79 rows=9,986 width=8) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Seq Scan on roadworkcontract c (cost=0.00..374.79 rows=9,986 width=8) (never executed)

  • Filter: isactive
Planning time : 1.358 ms