#	exclusive	inclusive	rows x	rows	loops	node
1.	0.017	0.094	↑ 1.0	8	1	→ Hash Join (cost=10.07..48.48 rows=8 width=255) (actual time=0.088..0.094 rows=8 loops=1) Hash Cond: (property_sku.sku_id = sku.id)
2.	0.013	0.027	↑ 1.1	8	1	→ Bitmap Heap Scan on property_sku (cost=4.41..42.71 rows=9 width=255) (actual time=0.023..0.027 rows=8 loops=1) Recheck Cond: ((property_id)::text = '0013487'::text) Filter: ((saleable IS TRUE) AND (status = 'ACTIVE'::property_sku_status)) Rows Removed by Filter: 11 Heap Blocks: exact=4
3.	0.014	0.014	↓ 1.1	19	1	→ Bitmap Index Scan on ix_property_sku_property_id (cost=0.00..4.41 rows=17 width=0) (actual time=0.014..0.014 rows=19 loops=1) Index Cond: ((property_id)::text = '0013487'::text)
4.	0.018	0.050	↑ 1.0	112	1	→ Hash (cost=4.26..4.26 rows=112 width=4) (actual time=0.050..0.050 rows=112 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 12kB
5.	0.032	0.032	↑ 1.0	112	1	→ Seq Scan on sku (cost=0.00..4.26 rows=112 width=4) (actual time=0.005..0.032 rows=112 loops=1) Filter: (is_modular IS FALSE) Rows Removed by Filter: 14

"Hash Join  (cost=10.07..48.48 rows=8 width=255) (actual time=0.088..0.094 rows=8 loops=1)"
"  Hash Cond: (property_sku.sku_id = sku.id)"
"  ->  Bitmap Heap Scan on property_sku  (cost=4.41..42.71 rows=9 width=255) (actual time=0.023..0.027 rows=8 loops=1)"
"        Recheck Cond: ((property_id)::text = '0013487'::text)"
"        Filter: ((saleable IS TRUE) AND (status = 'ACTIVE'::property_sku_status))"
"        Rows Removed by Filter: 11"
"        Heap Blocks: exact=4"
"        ->  Bitmap Index Scan on ix_property_sku_property_id  (cost=0.00..4.41 rows=17 width=0) (actual time=0.014..0.014 rows=19 loops=1)"
"              Index Cond: ((property_id)::text = '0013487'::text)"
"  ->  Hash  (cost=4.26..4.26 rows=112 width=4) (actual time=0.050..0.050 rows=112 loops=1)"
"        Buckets: 1024  Batches: 1  Memory Usage: 12kB"
"        ->  Seq Scan on sku  (cost=0.00..4.26 rows=112 width=4) (actual time=0.005..0.032 rows=112 loops=1)"
"              Filter: (is_modular IS FALSE)"
"              Rows Removed by Filter: 14"
"Planning time: 0.328 ms"
"Execution time: 0.139 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.013 ms	13.8 %
Bitmap Index Scan	1	0.014 ms	14.9 %
Hash	1	0.018 ms	19.1 %
Hash Join	1	0.017 ms	18.1 %
Seq Scan	1	0.032 ms	34.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
property_sku	1	0.013 ms	13.8 %
Bitmap Heap Scan	1	0.013 ms	100.0 %
sku	1	0.032 ms	34.0 %
Seq Scan	1	0.032 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OWji

Color mode:

Visible columns:

Per node type stats

Per table stats