explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2gyk

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 2,011.648 ↓ 0.0 0 1

Update on delivery_order (cost=0.00..79,472.56 rows=1 width=1,291) (actual time=2,011.648..2,011.648 rows=0 loops=1)

2. 2,011.645 2,011.645 ↓ 0.0 0 1

Seq Scan on delivery_order (cost=0.00..79,472.56 rows=1 width=1,291) (actual time=2,011.645..2,011.645 rows=0 loops=1)

  • Filter: (queued_for_manifest AND (COALESCE(held, false) OR COALESCE(voided, false) OR (COALESCE(avoid_scheduled_runs, false) AND COALESCE(avoid_saved_manifest, false))) AND (integration_feed <> 'Integration Pulse'::text))
  • Rows Removed by Filter: 1727383