explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vNfG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=289,997.06..289,997.07 rows=1 width=1,306) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=289,997.06..289,997.07 rows=1 width=1,306) (never executed)

  • Sort Key: ctr_price_update.file_timestamp_date DESC NULLS LAST, ctr_price_update.id DESC
3. 0.000 0.000 ↓ 0.0

Seq Scan on ctr_price_update ctr_price_update (cost=0..289,997.05 rows=1 width=1,306) (never executed)

  • Filter: ((ctr_price_update.sku = '846315 025'::text) AND (ctr_price_update.designer_id = '846315025'::text) AND (ctr_price_update.barcode = '72171'::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))