explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CXBA

Settings
# exclusive inclusive rows x rows loops node
1. 47.866 68.294 ↑ 109.5 91 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.146 20.428 ↑ 138.5 30 3

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

3. 20.279 20.279 ↑ 138.5 30 3

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

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

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

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