explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCGb

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 249.432 ↑ 1.0 1 1

Aggregate (cost=29,765.95..29,765.96 rows=1 width=24) (actual time=249.432..249.432 rows=1 loops=1)

2. 0.000 249.428 ↓ 0.0 0 1

Unique (cost=29,750.55..29,753.85 rows=440 width=14) (actual time=249.428..249.428 rows=0 loops=1)

3. 0.004 249.428 ↓ 0.0 0 1

Sort (cost=29,750.55..29,751.65 rows=440 width=14) (actual time=249.428..249.428 rows=0 loops=1)

  • Sort Key: subordertable.orderid, subordertable.subordermodeofpayment
  • Sort Method: quicksort Memory: 25kB
4. 0.087 249.424 ↓ 0.0 0 1

Bitmap Heap Scan on subordertable (cost=23,337.21..29,731.24 rows=440 width=14) (actual time=249.424..249.424 rows=0 loops=1)

  • Recheck Cond: ((storeid = 1,041,992) AND (date((time_stamp + '05:30:00'::interval)) >= '2020-09-09'::date) AND (date((time_stamp + '05:30:00'::interval)) <= '2020-10-09'::date))
  • Filter: ((parentstoreid IS NULL) AND (suborderstatusvalue <> ALL ('{5,6}'::bigint[])))
5. 2.148 249.337 ↓ 0.0 0 1

BitmapAnd (cost=23,337.21..23,337.21 rows=1,643 width=0) (actual time=249.337..249.337 rows=0 loops=1)

6. 86.852 86.852 ↓ 1.0 33,345 1

Bitmap Index Scan on idx_storeid_subordertable (cost=0.00..750.81 rows=31,784 width=0) (actual time=86.852..86.852 rows=33,345 loops=1)

  • Index Cond: (storeid = 1,041,992)
7. 160.337 160.337 ↓ 1.7 1,094,607 1

Bitmap Index Scan on idx_date_subordertable (cost=0.00..22,585.92 rows=648,549 width=0) (actual time=160.337..160.337 rows=1,094,607 loops=1)

  • Index Cond: ((date((time_stamp + '05:30:00'::interval)) >= '2020-09-09'::date) AND (date((time_stamp + '05:30:00'::interval)) <= '2020-10-09'::date))
Planning time : 0.168 ms
Execution time : 253.990 ms