explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oRaIy : Optimization for: plan #ffln

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.036 ↑ 1.0 1 1

Limit (cost=8.45..8.46 rows=1 width=1,306) (actual time=0.036..0.036 rows=1 loops=1)

2. 0.009 0.035 ↑ 1.0 1 1

Sort (cost=8.45..8.46 rows=1 width=1,306) (actual time=0.035..0.035 rows=1 loops=1)

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

Index Scan using ctr_price_update_idxproductnobarcodeandstatus on ctr_price_update ctr_price_update (cost=0.41..8.44 rows=1 width=1,306) (actual time=0.023..0.026 rows=2 loops=1)

  • Index Cond: ((ctr_price_update.sku = 'MAS03W19P786513130'::text) AND (ctr_price_update.designer_id = '2CM206 053'::text) AND (ctr_price_update.barcode IS NULL) AND (ctr_price_update.tenant_id = '10000'::text) AND (ctr_price_update.site_id = '9359'::text) AND (ctr_price_update.price_status = 'FC'::bpchar))
  • Filter: (ctr_price_update.activity_type = 'PRP'::text)