explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xods

Settings
# exclusive inclusive rows x rows loops node
1. 941.014 57,239.994 ↓ 2.5 500 1

GroupAggregate (cost=1,517.69..1,530.83 rows=200 width=16) (actual time=55,297.759..57,239.994 rows=500 loops=1)

  • Group Key: s.sample_hour
2. 2,005.339 56,298.980 ↓ 4,514.8 1,498,911 1

Sort (cost=1,517.69..1,518.52 rows=332 width=32) (actual time=55,296.101..56,298.980 rows=1,498,911 loops=1)

  • Sort Key: s.sample_hour
  • Sort Method: quicksort Memory: 130,346kB
3. 232.524 54,293.641 ↓ 4,514.8 1,498,911 1

Append (cost=28.82..1,503.79 rows=332 width=32) (actual time=1,353.607..54,293.641 rows=1,498,911 loops=1)

  • Subplans Removed: 1
4. 6,844.781 8,191.563 ↓ 1,447.5 211,328 1

Bitmap Heap Scan on sample_2019_08_alvjcabb00t s (cost=98.04..659.69 rows=146 width=32) (actual time=1,353.605..8,191.563 rows=211,328 loops=1)

  • Recheck Cond: (((switch_name)::text = 'ALVJCABB00T'::text) AND (sample_hour >= (now() - '31 days'::interval)))
  • Heap Blocks: exact=7,373
5. 1,346.782 1,346.782 ↓ 1,447.5 211,328 1

Bitmap Index Scan on sample_2019_08_alvjcabb00t_switch_name_sample_hour_group_ke_idx (cost=0.00..98.01 rows=146 width=0) (actual time=1,346.781..1,346.782 rows=211,328 loops=1)

  • Index Cond: (((switch_name)::text = 'ALVJCABB00T'::text) AND (sample_hour >= (now() - '31 days'::interval)))
6. 39,163.642 45,869.554 ↓ 8,759.1 1,287,583 1

Bitmap Heap Scan on sample_2019_09_alvjcabb00t s_1 (cost=98.05..663.58 rows=147 width=32) (actual time=6,741.063..45,869.554 rows=1,287,583 loops=1)

  • Recheck Cond: (((switch_name)::text = 'ALVJCABB00T'::text) AND (sample_hour >= (now() - '31 days'::interval)))
  • Heap Blocks: exact=44,246
7. 6,705.912 6,705.912 ↓ 8,786.7 1,291,643 1

Bitmap Index Scan on sample_2019_09_alvjcabb00t_switch_name_sample_hour_group_ke_idx (cost=0.00..98.02 rows=147 width=0) (actual time=6,705.912..6,705.912 rows=1,291,643 loops=1)

  • Index Cond: (((switch_name)::text = 'ALVJCABB00T'::text) AND (sample_hour >= (now() - '31 days'::interval)))