explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yVAJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.920 ↑ 132.6 7 1

Sort (cost=5,303.91..5,306.23 rows=928 width=16) (actual time=0.920..0.920 rows=7 loops=1)

  • Sort Key: (date_part('isodow'::text, "timestamp"))
  • Sort Method: quicksort Memory: 25kB
2. 0.128 0.913 ↑ 132.6 7 1

HashAggregate (cost=5,244.25..5,258.17 rows=928 width=16) (actual time=0.909..0.913 rows=7 loops=1)

  • Group Key: date_part('isodow'::text, "timestamp")
3. 0.570 0.785 ↑ 1.7 786 1

Bitmap Heap Scan on perf_metric_hourly ph (cost=77.36..5,237.62 rows=1,326 width=16) (actual time=0.237..0.785 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=137
4. 0.215 0.215 ↑ 1.7 793 1

Bitmap Index Scan on perf_metric_hourly_unique_pkey (cost=0.00..77.03 rows=1,326 width=0) (actual time=0.215..0.215 rows=793 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))