explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EPLW

Settings
# exclusive inclusive rows x rows loops node
1. 36.069 239.395 ↑ 1.0 137,702 1

Unique (cost=22,904.72..23,593.23 rows=137,702 width=81) (actual time=169.109..239.395 rows=137,702 loops=1)

2. 156.597 203.326 ↑ 1.0 137,702 1

Sort (cost=22,904.72..23,248.97 rows=137,702 width=81) (actual time=169.108..203.326 rows=137,702 loops=1)

  • Sort Key: sku_id, active_at DESC, store_id
  • Sort Method: external merge Disk: 14296kB
3. 46.729 46.729 ↑ 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.012..46.729 rows=137,702 loops=1)

  • Filter: ((store_id IS NULL) AND (active_at <= '2019-03-08 10:05:15.331055'::timestamp without time zone) AND ((currency_code)::text = 'HKD'::text))