explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jPfJ : Optimization for: Q2; plan #4vyk

Settings

Optimization path:

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

Limit (cost=8.59..8.6 rows=1 width=108) (actual time=0.431..0.431 rows=1 loops=1)

2. 0.087 0.431 ↑ 1.0 1 1

Sort (cost=8.59..8.6 rows=1 width=108) (actual time=0.431..0.431 rows=1 loops=1)

  • Sort Key: ctr_price_update.file_timestamp_date DESC NULLS LAST, ctr_price_update.id DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.344 0.344 ↓ 194.0 194 1

Index Scan using ctr_price_update_idxproductbarcodeandstatus on ctr_price_update ctr_price_update (cost=0.55..8.58 rows=1 width=108) (actual time=0.028..0.344 rows=194 loops=1)

  • Index Cond: ((ctr_price_update.sku = '162204C'::text) AND (ctr_price_update.designer_id = '162204C'::text) AND (ctr_price_update.barcode = '251227'::text) AND (ctr_price_update.tenant_id = '10000'::text) AND (ctr_price_update.site_id = '11218'::text) AND (ctr_price_update.price_status = 'FC'::bpchar))