explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FO7a

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 1.690 ↑ 28.6 7 1

Sort (cost=7,299.04..7,299.54 rows=200 width=16) (actual time=1.690..1.690 rows=7 loops=1)

  • Sort Key: (date_part('isodow'::text, ph."timestamp"))
  • Sort Method: quicksort Memory: 25kB
2. 0.322 1.682 ↑ 28.6 7 1

HashAggregate (cost=7,288.40..7,291.40 rows=200 width=16) (actual time=1.678..1.682 rows=7 loops=1)

  • Group Key: (date_part('isodow'::text, ph."timestamp"))
3. 0.088 1.360 ↑ 2.4 786 1

Append (cost=0.15..7,278.93 rows=1,893 width=16) (actual time=0.401..1.360 rows=786 loops=1)

  • Subplans Removed: 15
4. 0.854 1.132 ↑ 1.1 786 1

Bitmap Heap Scan on testdate2019jan_april_perfmetrichourly_mod3rem0 ph (cost=46.60..3,336.73 rows=884 width=16) (actual time=0.400..1.132 rows=786 loops=1)

  • Recheck Cond: (((resource_id)::text = ANY ('{abziespaxu,acnzcgboud}'::text[])) AND ((metric_type)::text = 'CPU_UTILIZATION'::text) AND ("timestamp" >= (CURRENT_DATE - 30)) AND ("timestamp" <= CURRENT_DATE))
  • Heap Blocks: exact=135
5. 0.278 0.278 ↑ 1.1 786 1

Bitmap Index Scan on testdate2019jan_april_perfmet_resource_id_metric_type_times_idx (cost=0.00..46.38 rows=884 width=0) (actual time=0.278..0.278 rows=786 loops=1)

  • Index Cond: (((resource_id)::text = ANY ('{abziespaxu,acnzcgboud}'::text[])) AND ((metric_type)::text = 'CPU_UTILIZATION'::text) AND ("timestamp" >= (CURRENT_DATE - 30)) AND ("timestamp" <= CURRENT_DATE))
6. 0.001 0.068 ↓ 0.0 0 1

Bitmap Heap Scan on testdate2019jan_april_perfmetrichourly_mod3rem1 ph_1 (cost=36.16..2,725.49 rows=723 width=16) (actual time=0.068..0.068 rows=0 loops=1)

  • Recheck Cond: (((resource_id)::text = ANY ('{abziespaxu,acnzcgboud}'::text[])) AND ((metric_type)::text = 'CPU_UTILIZATION'::text) AND ("timestamp" >= (CURRENT_DATE - 30)) AND ("timestamp" <= CURRENT_DATE))
7. 0.067 0.067 ↓ 0.0 0 1

Bitmap Index Scan on testdate2019jan_april_perfmet_resource_id_metric_type_time_idx1 (cost=0.00..35.98 rows=723 width=0) (actual time=0.067..0.067 rows=0 loops=1)

  • Index Cond: (((resource_id)::text = ANY ('{abziespaxu,acnzcgboud}'::text[])) AND ((metric_type)::text = 'CPU_UTILIZATION'::text) AND ("timestamp" >= (CURRENT_DATE - 30)) AND ("timestamp" <= CURRENT_DATE))
8. 0.001 0.072 ↓ 0.0 0 1

Bitmap Heap Scan on testdate2019jan_april_perfmetrichourly_mod3rem2 ph_2 (cost=21.25..1,080.51 rows=271 width=16) (actual time=0.072..0.072 rows=0 loops=1)

  • Recheck Cond: (((resource_id)::text = ANY ('{abziespaxu,acnzcgboud}'::text[])) AND ((metric_type)::text = 'CPU_UTILIZATION'::text) AND ("timestamp" >= (CURRENT_DATE - 30)) AND ("timestamp" <= CURRENT_DATE))
9. 0.071 0.071 ↓ 0.0 0 1

Bitmap Index Scan on testdate2019jan_april_perfmet_resource_id_metric_type_time_idx2 (cost=0.00..21.18 rows=271 width=0) (actual time=0.071..0.071 rows=0 loops=1)

  • Index Cond: (((resource_id)::text = ANY ('{abziespaxu,acnzcgboud}'::text[])) AND ((metric_type)::text = 'CPU_UTILIZATION'::text) AND ("timestamp" >= (CURRENT_DATE - 30)) AND ("timestamp" <= CURRENT_DATE))