explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ne34

Settings
# exclusive inclusive rows x rows loops node
1. 61.473 9,325.342 ↑ 109.5 91 1

Gather (cost=1,000.28..13,632.13 rows=9,969 width=1,297) (actual time=4.258..9,325.342 rows=91 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 1.873 9,263.869 ↑ 138.5 30 3

Nested Loop (cost=0.28..11,635.23 rows=4,154 width=1,297) (actual time=78.693..9,263.869 rows=30 loops=3)

3. 9,261.945 9,261.945 ↑ 138.5 30 3

Parallel Seq Scan on permit "Extent1" (cost=0.00..9,905.80 rows=4,154 width=669) (actual time=78.595..9,261.945 rows=30 loops=3)

  • Filter: ((9 = permitstatustypeid) AND (approvedperiodto < LOCALTIMESTAMP))
  • Rows Removed by Filter: 54452
4. 0.051 0.051 ↑ 1.0 1 91

Index Scan using pk_organisation on organisation "Extent2" (cost=0.28..0.42 rows=1 width=628) (actual time=0.051..0.051 rows=1 loops=91)

  • Index Cond: (id = "Extent1".permitownerorganisationid)
Planning time : 353.540 ms