explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J41O

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

Limit (cost=4,607.04..27,637.94 rows=5 width=37) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..2,058,962.67 rows=447 width=37) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan Backward using orders_created_at_index on orders delivered_orders (cost=0.43..252,376.47 rows=3,647,888 width=37) (actual rows= loops=)

  • Filter: ((state)::text = ANY ('{pending_review,finished}'::text[]))
4. 0.000 0.000 ↓ 0.0

Index Scan using order_storekeepers_order_id_index on order_storekeepers (cost=0.43..0.49 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = delivered_orders.id)
  • Filter: (is_current AND (storekeeper_id = 1234))