#	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

"Hash Join  (cost=1193.18..12843.23 rows=9969 width=1297) (actual time=25.131..30.422 rows=91 loops=1)"
"  Hash Cond: ("Extent1".permitownerorganisationid = "Extent2".id)"
"  ->  Bitmap Heap Scan on permit "Extent1"  (cost=258.60..9569.82 rows=9969 width=669) (actual time=0.086..2.211 rows=91 loops=1)"
"        Recheck Cond: ((9 = permitstatustypeid) AND (approvedperiodto < LOCALTIMESTAMP))"
"        Heap Blocks: exact=86"
"        ->  Bitmap Index Scan on ix_permit_approvedperiodto_permitstatustypeid  (cost=0.00..256.11 rows=9969 width=0) (actual time=0.075..0.075 rows=91 loops=1)"
"              Index Cond: ((9 = permitstatustypeid) AND (approvedperiodto < LOCALTIMESTAMP))"
"  ->  Hash  (cost=334.70..334.70 rows=6470 width=628) (actual time=25.000..25.000 rows=6470 loops=1)"
"        Buckets: 8192  Batches: 2  Memory Usage: 1126kB"
"        ->  Seq Scan on organisation "Extent2"  (cost=0.00..334.70 rows=6470 width=628) (actual time=0.025..7.634 rows=6470 loops=1)"
"Planning time: 0.783 ms"
"Execution time: 30.711 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	2.136 ms	7.0 %
Bitmap Index Scan	1	0.075 ms	0.2 %
Hash	1	17.366 ms	57.1 %
Hash Join	1	3.211 ms	10.6 %
Seq Scan	1	7.634 ms	25.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
organisation	1	7.634 ms	25.1 %
Seq Scan	1	7.634 ms	100.0 %
permit	1	2.136 ms	7.0 %
Bitmap Heap Scan	1	2.136 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pVzY

Color mode:

Visible columns:

Per node type stats

Per table stats