explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9bVf

Settings
# exclusive inclusive rows x rows loops node
1. 0.315 1,638.775 ↑ 5.7 378 1

GroupAggregate (cost=20,576.32..20,630.37 rows=2,162 width=16) (actual time=1,638.335..1,638.775 rows=378 loops=1)

  • Group Key: company_id, ((date_created)::date)
2. 2.290 1,638.460 ↑ 1.8 1,223 1

Sort (cost=20,576.32..20,581.72 rows=2,162 width=16) (actual time=1,638.325..1,638.460 rows=1,223 loops=1)

  • Sort Key: company_id, ((date_created)::date)
  • Sort Method: quicksort Memory: 106kB
3. 1,636.170 1,636.170 ↑ 1.8 1,223 1

Index Scan using ix_order_date_created on "order" (cost=0.57..20,456.56 rows=2,162 width=16) (actual time=0.695..1,636.170 rows=1,223 loops=1)

  • Index Cond: ((date_created > '2019-09-29 00:00:00'::timestamp without time zone) AND (date_created <= '2019-09-30 00:00:00'::timestamp without time zone))
  • Filter: ((company_id > 0) AND (company_id <= 100,000))
  • Rows Removed by Filter: 61,805
Planning time : 0.247 ms
Execution time : 1,638.864 ms