#	exclusive	inclusive	rows x	rows	loops	node
1.	0.050	21.920	↓ 12.5	50	1	→ HashAggregate (cost=663.13..663.17 rows=4 width=4) (actual time=21.914..21.920 rows=50 loops=1)
2.	0.066	21.870	↓ 14.2	57	1	→ Hash Semi Join (cost=32.09..663.12 rows=4 width=4) (actual time=1.652..21.870 rows=57 loops=1) Hash Cond: (abmafile.abmafileid = catalog.sku.abmafileid)
3.	14.002	21.224	↓ 14.2	57	1	→ Nested Loop Anti Join (cost=12.14..643.09 rows=4 width=8) (actual time=1.054..21.224 rows=57 loops=1) Join Filter: (((catalog.sku.abmafileid = abmafile.abmafileid) AND (catalog.sku.datestop IS NULL)) OR (catalog.sku.datestop >= now()))
4.	0.184	0.544	↓ 1.3	63	1	→ Hash Join (cost=12.14..37.26 rows=50 width=8) (actual time=0.172..0.544 rows=63 loops=1) Hash Cond: (abmafile.abmafileid = catalog.sku.abmafileid)
5.	0.233	0.233	↓ 1.0	573	1	→ Seq Scan on abmafile (cost=0.00..19.66 rows=566 width=4) (actual time=0.007..0.233 rows=573 loops=1)
6.	0.033	0.127	↓ 1.3	63	1	→ Hash (cost=11.52..11.52 rows=50 width=4) (actual time=0.127..0.127 rows=63 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 3kB
7.	0.043	0.094	↓ 1.3	63	1	→ Bitmap Heap Scan on sku (cost=4.64..11.52 rows=50 width=4) (actual time=0.057..0.094 rows=63 loops=1) Recheck Cond: (datestop >= (now() - '48:00:00'::interval))
8.	0.051	0.051	↓ 1.3	63	1	→ Bitmap Index Scan on idx_sku_date_stop (cost=0.00..4.63 rows=50 width=0) (actual time=0.051..0.051 rows=63 loops=1) Index Cond: (datestop >= (now() - '48:00:00'::interval))
9.	6.404	6.678	↑ 1.0	597	63	→ Materialize (cost=0.00..15.30 rows=620 width=12) (actual time=0.000..0.106 rows=597 loops=63)
10.	0.274	0.274	↓ 1.0	635	1	→ Seq Scan on sku (cost=0.00..12.20 rows=620 width=12) (actual time=0.006..0.274 rows=635 loops=1)
11.	0.328	0.580	↓ 1.0	635	1	→ Hash (cost=12.20..12.20 rows=620 width=4) (actual time=0.580..0.580 rows=635 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 23kB
12.	0.252	0.252	↓ 1.0	635	1	→ Seq Scan on sku (cost=0.00..12.20 rows=620 width=4) (actual time=0.005..0.252 rows=635 loops=1)

HashAggregate  (cost=663.13..663.17 rows=4 width=4) (actual time=21.914..21.920 rows=50 loops=1)
  ->  Hash Semi Join  (cost=32.09..663.12 rows=4 width=4) (actual time=1.652..21.870 rows=57 loops=1)
        Hash Cond: (abmafile.abmafileid = catalog.sku.abmafileid)
        ->  Nested Loop Anti Join  (cost=12.14..643.09 rows=4 width=8) (actual time=1.054..21.224 rows=57 loops=1)
              Join Filter: (((catalog.sku.abmafileid = abmafile.abmafileid) AND (catalog.sku.datestop IS NULL)) OR (catalog.sku.datestop >= now()))
              ->  Hash Join  (cost=12.14..37.26 rows=50 width=8) (actual time=0.172..0.544 rows=63 loops=1)
                    Hash Cond: (abmafile.abmafileid = catalog.sku.abmafileid)
                    ->  Seq Scan on abmafile  (cost=0.00..19.66 rows=566 width=4) (actual time=0.007..0.233 rows=573 loops=1)
                    ->  Hash  (cost=11.52..11.52 rows=50 width=4) (actual time=0.127..0.127 rows=63 loops=1)
                          Buckets: 1024  Batches: 1  Memory Usage: 3kB
                          ->  Bitmap Heap Scan on sku  (cost=4.64..11.52 rows=50 width=4) (actual time=0.057..0.094 rows=63 loops=1)
                                Recheck Cond: (datestop >= (now() - '48:00:00'::interval))
                                ->  Bitmap Index Scan on idx_sku_date_stop  (cost=0.00..4.63 rows=50 width=0) (actual time=0.051..0.051 rows=63 loops=1)
                                      Index Cond: (datestop >= (now() - '48:00:00'::interval))
              ->  Materialize  (cost=0.00..15.30 rows=620 width=12) (actual time=0.000..0.106 rows=597 loops=63)
                    ->  Seq Scan on sku  (cost=0.00..12.20 rows=620 width=12) (actual time=0.006..0.274 rows=635 loops=1)
        ->  Hash  (cost=12.20..12.20 rows=620 width=4) (actual time=0.580..0.580 rows=635 loops=1)
              Buckets: 1024  Batches: 1  Memory Usage: 23kB
              ->  Seq Scan on sku  (cost=0.00..12.20 rows=620 width=4) (actual time=0.005..0.252 rows=635 loops=1)
Total runtime: 22.031 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.043 ms	0.2 %
Bitmap Index Scan	1	0.051 ms	0.2 %
Hash	2	0.361 ms	1.6 %
Hash Join	1	0.184 ms	0.8 %
Hash Semi Join	1	0.066 ms	0.3 %
HashAggregate	1	0.050 ms	0.2 %
Materialize	1	6.404 ms	29.2 %
Nested Loop Anti Join	1	14.002 ms	63.9 %
Seq Scan	3	0.759 ms	3.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
abmafile	1	0.233 ms	1.1 %
Seq Scan	1	0.233 ms	100.0 %
sku	3	0.569 ms	2.6 %
Bitmap Heap Scan	1	0.043 ms	7.6 %
Seq Scan	2	0.526 ms	92.4 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 9bS

Colorize:

Columns visibility:

Per node type stats

Per table stats