explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p6lT : Optimization for: plan #mjx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 10.064 4,157.657 ↑ 6.4 8,634 1
→

GroupAggregate (cost=802,012.73..803,686.99 rows=55,659 width=26) (actual time=4,145.924..4,157.657 rows=8,634 loops=1)

  • Group Key: geo_id, ""time"
2. 18.536 4,147.593 ↑ 2.8 19,977 1
→

Sort (cost=802,012.73..802,153.00 rows=56,108 width=18) (actual time=4,145.887..4,147.593 rows=19,977 loops=1)

  • Sort Key: geo_id, ""time"
  • Sort Method: quicksort Memory: 2329kB
3. 3,502.055 4,129.057 ↑ 2.8 19,977 1
→

Bitmap Heap Scan on agg_counts_by_minute (cost=151,817.83..797,586.95 rows=56,108 width=18) (actual time=3,689.420..4,129.057 rows=19,977 loops=1)

  • Recheck Cond: ((region_id)::text = 'arlington'::text)
  • Filter: (((day_str)::text >= '2019-02-01'::text) AND ((day_str)::text <= '2019-02-07'::text) AND ((operator)::text = 'lime'::text) AND ((level)::text = 'l1'::text) AND (date_part('dow'::text, ((day_str)::date)::timestamp without time zone) <> ALL ('{0,6}'::double precision[])))
  • Rows Removed by Filter: 7466851
  • Heap Blocks: exact=106582
4. 627.002 627.002 ↓ 1.1 7,486,828 1
→

Bitmap Index Scan on region_id (cost=0.00..151,803.80 rows=6,824,432 width=0) (actual time=627.002..627.002 rows=7,486,828 loops=1)

  • Index Cond: ((region_id)::text = 'arlington'::text)