explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NCB8 : Optimization for: plan #7DUz

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.036 1,700.325 ↑ 1.0 1 1

Aggregate (cost=141,210.87..141,210.88 rows=1 width=8) (actual time=1,700.325..1,700.325 rows=1 loops=1)

2. 298.106 1,700.289 ↑ 523.0 106 1

Hash Join (cost=51,325.39..141,072.28 rows=55,439 width=0) (actual time=1,625.080..1,700.289 rows=106 loops=1)

3. 1,353.089 1,353.089 ↓ 1.0 1,573,965 1

Seq Scan on orders_orderinfo oi (cost=0.00..83,290.54 rows=1,573,854 width=24) (actual time=0.006..1,353.089 rows=1,573,965 loops=1)

4. 0.047 49.094 ↑ 523.2 106 1

Hash (cost=50,632.12..50,632.12 rows=55,462 width=8) (actual time=49.094..49.094 rows=106 loops=1)

5. 49.047 49.047 ↑ 523.2 106 1

Index Scan using idx_datetime_create on orders_order oo (cost=0.43..50,632.12 rows=55,462 width=8) (actual time=0.386..49.047 rows=106 loops=1)

  • Index Cond: ((datetime_created >= '2019-09-01 00:00:00+06'::timestamp with time zone) AND (datetime_created <= '2019-09-30 23:59:59+06'::timestamp with time zone))
  • Filter: ((delete_timestamp IS NULL) AND ((status)::text <> 'cancelled'::text) AND ((cancelled_side)::text <> 'site'::text))