explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 9bS

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# 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)