explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I97

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 62.174 ↑ 1.0 60 1

Limit (cost=10,308.01..10,308.16 rows=60 width=2,115) (actual time=62.165..62.174 rows=60 loops=1)

2. 23.699 62.166 ↑ 154.3 60 1

Sort (cost=10,308.01..10,331.17 rows=9,261 width=2,115) (actual time=62.163..62.166 rows=60 loops=1)

  • Sort Key: ttna NULLS FIRST
  • Sort Method: top-N heapsort Memory: 116kB
3. 38.467 38.467 ↓ 1.2 10,828 1

Index Scan using index_shipments_on_state on shipments (cost=0.43..9,988.19 rows=9,261 width=2,115) (actual time=0.095..38.467 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 : 0.753 ms
Execution time : 62.301 ms