explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xpfD

Settings
# exclusive inclusive rows x rows loops node
1. 171.073 519.426 ↑ 1.0 137,702 1

Hash Join (cost=27,087.51..32,743.52 rows=137,702 width=81) (actual time=260.954..519.426 rows=137,702 loops=1)

  • Hash Cond: (active_sku_catalog_price_caches.id = sku_catalog_price_caches.id)
2. 22.129 239.519 ↑ 1.0 137,702 1

Subquery Scan on active_sku_catalog_price_caches (cost=18,922.71..20,988.24 rows=137,702 width=16) (actual time=151.828..239.519 rows=137,702 loops=1)

3. 35.022 217.390 ↑ 1.0 137,702 1

Unique (cost=18,922.71..19,611.22 rows=137,702 width=32) (actual time=151.827..217.390 rows=137,702 loops=1)

4. 144.131 182.368 ↑ 1.0 137,702 1

Sort (cost=18,922.71..19,266.96 rows=137,702 width=32) (actual time=151.826..182.368 rows=137,702 loops=1)

  • Sort Key: sku_catalog_price_caches_1.sku_id, sku_catalog_price_caches_1.active_at DESC, sku_catalog_price_caches_1.store_id
  • Sort Method: external merge Disk: 5672kB
5. 38.237 38.237 ↑ 1.0 137,702 1

Seq Scan on sku_catalog_price_caches sku_catalog_price_caches_1 (cost=0.00..3,872.02 rows=137,702 width=32) (actual time=0.011..38.237 rows=137,702 loops=1)

6. 57.178 108.834 ↑ 1.0 137,702 1

Hash (cost=4,560.53..4,560.53 rows=137,702 width=81) (actual time=108.834..108.834 rows=137,702 loops=1)

  • Buckets: 32768 Batches: 8 Memory Usage: 2387kB
7. 51.656 51.656 ↑ 1.0 137,702 1

Seq Scan on sku_catalog_price_caches (cost=0.00..4,560.53 rows=137,702 width=81) (actual time=0.013..51.656 rows=137,702 loops=1)

  • Filter: ((store_id IS NULL) AND (active_at <= '2019-03-11 04:20:09.132652'::timestamp without time zone) AND ((currency_code)::text = 'HKD'::text))