explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KOHh

Settings
# exclusive inclusive rows x rows loops node
1. 166.336 963.391 ↓ 9.0 137,702 1

Hash Join (cost=62,001.11..64,303.50 rows=15,285 width=81) (actual time=710.657..963.391 rows=137,702 loops=1)

  • Hash Cond: (active_sku_catalog_price_caches.id = sku_catalog_price_caches.id)
2. 21.776 687.764 ↓ 9.0 137,702 1

Subquery Scan on active_sku_catalog_price_caches (cost=53,836.30..54,065.58 rows=15,285 width=16) (actual time=601.104..687.764 rows=137,702 loops=1)

3. 35.018 665.988 ↓ 9.0 137,702 1

Unique (cost=53,836.30..53,912.73 rows=15,285 width=32) (actual time=601.101..665.988 rows=137,702 loops=1)

4. 158.033 630.970 ↓ 9.0 137,702 1

Sort (cost=53,836.30..53,874.51 rows=15,285 width=32) (actual time=601.100..630.970 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. 129.256 472.937 ↓ 9.0 137,702 1

Hash Join (cost=48,540.51..52,774.01 rows=15,285 width=32) (actual time=323.291..472.937 rows=137,702 loops=1)

  • Hash Cond: (sku_catalog_price_caches_1.sku_id = skus.id)
6. 20.463 20.463 ↑ 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..20.463 rows=137,702 loops=1)

7. 42.783 323.218 ↓ 9.0 137,702 1

Hash (cost=48,348.86..48,348.86 rows=15,332 width=4) (actual time=323.218..323.218 rows=137,702 loops=1)

  • Buckets: 131072 (originally 16384) Batches: 2 (originally 1) Memory Usage: 3445kB
8. 280.435 280.435 ↓ 9.0 137,702 1

Seq Scan on skus (cost=0.00..48,348.86 rows=15,332 width=4) (actual time=0.009..280.435 rows=137,702 loops=1)

  • Filter: (usable AND (NOT dummy) AND (id IS NOT NULL) AND ('2019-03-11 04:20:09.132799'::timestamp without time zone >= COALESCE(start_display_date_cache, '2019-03-09 16:00:00'::timestamp without time zone)) AND ('2019-03-11 04:20:09.132799'::timestamp without time zone <= COALESCE(end_display_date_cache, '2019-03-16 15:59:59.999999'::timestamp without time zone)) AND ((product_status_cache)::text = 'published'::text) AND ((color_option_status_cache)::text = 'published'::text) AND ((size_option_status_cache)::text = 'published'::text))
  • Rows Removed by Filter: 155
9. 57.144 109.291 ↑ 1.0 137,702 1

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

  • Buckets: 32768 Batches: 8 Memory Usage: 2387kB
10. 52.147 52.147 ↑ 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..52.147 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))