explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uLzE

Settings
# exclusive inclusive rows x rows loops node
1. 19,389.895 20,518.906 ↑ 2.0 82,737 1

Bitmap Heap Scan on deliverystatisticswithdetail (cost=73,956.76..374,220.43 rows=161,654 width=25) (actual time=1,135.136..20,518.906 rows=82,737 loops=1)

  • Recheck Cond: ((creationdate >= '2019-08-08'::date) AND (creationdate <= '2019-09-08'::date) AND (customerid = '5530'::text))
  • Heap Blocks: exact=32449
2. 1,129.011 1,129.011 ↑ 2.0 82,823 1

Bitmap Index Scan on deliverystatisticswithdetail_creationdate_customer_idx (cost=0.00..73,916.35 rows=161,654 width=0) (actual time=1,129.011..1,129.011 rows=82,823 loops=1)

  • Index Cond: ((creationdate >= '2019-08-08'::date) AND (creationdate <= '2019-09-08'::date) AND (customerid = '5530'::text))
Planning time : 1.961 ms