explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wDZk

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 1,538.181 ↑ 1.0 1 1

Limit (cost=456,301.88..456,301.89 rows=1 width=108) (actual time=1,538.181..1,538.181 rows=1 loops=1)

2. 0.024 1,538.181 ↑ 1.0 1 1

Sort (cost=456,301.88..456,301.89 rows=1 width=108) (actual time=1,538.181..1,538.181 rows=1 loops=1)

  • Sort Key: ctr_price_update.file_timestamp_date DESC NULLS LAST, ctr_price_update.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 1,538.157 1,538.157 ↓ 2.0 2 1

Seq Scan on ctr_price_update ctr_price_update (cost=0..456,301.87 rows=1 width=108) (actual time=1,230.567..1,538.157 rows=2 loops=1)

  • Filter: ((ctr_price_update.barcode IS NULL) AND (ctr_price_update.activity_type = ANY ('{PRP-CHPX,PRP}'::text[])) AND (ctr_price_update.sku = 'O2S14W19125B111'::text) AND (ctr_price_update.designer_id = 'H006B'::text) AND (ctr_price_update.tenant_id = '10000'::text) AND (ctr_price_update.site_id = '9359'::text) AND (ctr_price_update.price_status = 'FC'::bpchar) AND (ctr_price_update.price_type = 'LMP'::text))