explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LsI8

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 459.911 ↓ 0.0 0 1

Limit (cost=4,085.87..4,085.88 rows=1 width=253) (actual time=459.911..459.911 rows=0 loops=1)

2. 0.007 459.910 ↓ 0.0 0 1

Sort (cost=4,085.87..4,085.88 rows=1 width=253) (actual time=459.910..459.910 rows=0 loops=1)

  • Sort Key: order0_.created_date DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.355 459.903 ↓ 0.0 0 1

Nested Loop (cost=1.27..4,085.86 rows=1 width=253) (actual time=459.903..459.903 rows=0 loops=1)

4. 44.060 44.060 ↓ 1.6 1,082 1

Index Scan using order_delivery_order_state_created_date_idx on order_delivery order0_ (cost=0.70..1,012.74 rows=657 width=253) (actual time=0.058..44.060 rows=1,082 loops=1)

  • Index Cond: (((order_state)::text = ANY ('{ALLOCATION_FAILED,ALLOCATING,DELIVERY_ACCEPTED,PENDING,CONFIRMED}'::text[])) AND (created_date >= '2020-09-08 02:00:00'::timestamp without time zone) AND (created_date <= '2020-09-09 01:59:05'::timestamp without time zone))
5. 415.488 415.488 ↓ 0.0 0 1,082

Index Scan using pk_locality on locality origin1_ (cost=0.57..4.68 rows=1 width=8) (actual time=0.384..0.384 rows=0 loops=1,082)

  • Index Cond: (id = order0_.origin_id)
  • Filter: (country_id = 2)
  • Rows Removed by Filter: 1
Planning time : 0.530 ms
Execution time : 459.959 ms