explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pVzY

Settings
# exclusive inclusive rows x rows loops node
1. 3.211 30.422 ↑ 109.5 91 1

Hash Join (cost=1,193.18..12,843.23 rows=9,969 width=1,297) (actual time=25.131..30.422 rows=91 loops=1)

  • Hash Cond: ("Extent1".permitownerorganisationid = "Extent2".id)
2. 2.136 2.211 ↑ 109.5 91 1

Bitmap Heap Scan on permit "Extent1" (cost=258.60..9,569.82 rows=9,969 width=669) (actual time=0.086..2.211 rows=91 loops=1)

  • Recheck Cond: ((9 = permitstatustypeid) AND (approvedperiodto < LOCALTIMESTAMP))
  • Heap Blocks: exact=86
3. 0.075 0.075 ↑ 109.5 91 1

Bitmap Index Scan on ix_permit_approvedperiodto_permitstatustypeid (cost=0.00..256.11 rows=9,969 width=0) (actual time=0.075..0.075 rows=91 loops=1)

  • Index Cond: ((9 = permitstatustypeid) AND (approvedperiodto < LOCALTIMESTAMP))
4. 17.366 25.000 ↑ 1.0 6,470 1

Hash (cost=334.70..334.70 rows=6,470 width=628) (actual time=25.000..25.000 rows=6,470 loops=1)

  • Buckets: 8192 Batches: 2 Memory Usage: 1126kB
5. 7.634 7.634 ↑ 1.0 6,470 1

Seq Scan on organisation "Extent2" (cost=0.00..334.70 rows=6,470 width=628) (actual time=0.025..7.634 rows=6,470 loops=1)

Planning time : 0.783 ms