explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ype3

Settings
# exclusive inclusive rows x rows loops node
1. 67.242 86.432 ↑ 109.5 91 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.125 19.190 ↑ 138.5 30 3

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

3. 19.063 19.063 ↑ 138.5 30 3

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

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

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

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