explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R2BT

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

Unique (cost=333.40..333.41 rows=1 width=4) (actual time=0.942..0.942 rows=0 loops=1)

2. 0.016 0.942 ↓ 0.0 0 1

Sort (cost=333.40..333.40 rows=1 width=4) (actual time=0.942..0.942 rows=0 loops=1)

  • Sort Key: orders.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.926 ↓ 0.0 0 1

Nested Loop (cost=1.00..333.39 rows=1 width=4) (actual time=0.926..0.926 rows=0 loops=1)

4. 0.585 0.585 ↓ 2.1 90 1

Index Scan using orders_application_user_id_index on orders (cost=0.56..218.47 rows=43 width=4) (actual time=0.017..0.585 rows=90 loops=1)

  • Index Cond: (application_user_id = 11156202)
  • Filter: ((created_at > (('now'::cstring)::date - '90 days'::interval)) AND ((state)::text = ANY ('{storekeeper_payment_canceled,storekeeper_payment_in_analysis,paid_to_sk,paid_verification_fail,not_taked,on_appeal,scheduled,canceled,canceled_by_partner_inactivity,canceled_partner_order_refused,canceled_for_refund,canceled_from_cms,in_progress,canceled_by_user_app_with_charge,finished,pending_review}'::text[])))
  • Rows Removed by Filter: 457
5. 0.360 0.360 ↓ 0.0 0 90

Index Scan using order_stores_order_id_index on order_stores (cost=0.43..2.66 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=90)

  • Index Cond: (order_id = orders.id)
  • Filter: ((type)::text = ANY ('{rosas_eloy,Flores_piante_2,hortensias,decorazion,rosatel,andaluz,petalos_flores,crown_flores}'::text[]))
  • Rows Removed by Filter: 1
Planning time : 1.442 ms
Execution time : 0.980 ms