explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TF2V

Settings
# exclusive inclusive rows x rows loops node
1. 0.696 18.658 ↑ 1.0 1 1

Aggregate (cost=10,011.34..10,011.35 rows=1 width=8) (actual time=18.658..18.658 rows=1 loops=1)

2. 17.962 17.962 ↓ 1.2 10,828 1

Index Scan using index_shipments_on_state on shipments (cost=0.43..9,988.19 rows=9,261 width=0) (actual time=0.203..17.962 rows=10,828 loops=1)

  • Index Cond: ((state)::text = ANY ('{init,waiting_for_manual_correction,dispatching,pending_check_out,dispatched,picked_up,undeliverable,passed_on}'::text[]))
  • Filter: ((NOT is_quote) AND ((type)::text = 'TourShipment'::text))
  • Rows Removed by Filter: 1387
Planning time : 3.700 ms
Execution time : 18.775 ms