explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1d5n

Settings
# exclusive inclusive rows x rows loops node
1. 0.944 1.778 ↑ 1.0 48 1

Append (cost=4.80..176.12 rows=49 width=83) (actual time=0.161..1.778 rows=48 loops=1)

2. 0.395 0.442 ↑ 1.0 24 1

Bitmap Heap Scan on _hyper_2_4_chunk (cost=4.80..90.05 rows=25 width=83) (actual time=0.140..0.442 rows=24 loops=1)

  • Recheck Cond: ((location = 19) AND (measure = 6) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts < '2020-01-03 00:00:00+00'::timestamp with time zone))
  • Heap Blocks: exact=24
3. 0.047 0.047 ↑ 1.0 24 1

Bitmap Index Scan on _hyper_2_4_chunk_idx_datamart_measurement_location_measure_ts (cost=0.00..4.79 rows=25 width=0) (actual time=0.039..0.047 rows=24 loops=1)

  • Index Cond: ((location = 19) AND (measure = 6) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts < '2020-01-03 00:00:00+00'::timestamp with time zone))
4. 0.365 0.392 ↑ 1.0 24 1

Bitmap Heap Scan on _hyper_2_2_chunk (cost=4.78..85.82 rows=24 width=83) (actual time=0.039..0.392 rows=24 loops=1)

  • Recheck Cond: ((location = 19) AND (measure = 6) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts < '2020-01-03 00:00:00+00'::timestamp with time zone))
  • Heap Blocks: exact=24
5. 0.027 0.027 ↑ 1.0 24 1

Bitmap Index Scan on _hyper_2_2_chunk_idx_datamart_measurement_location_measure_ts (cost=0.00..4.78 rows=24 width=0) (actual time=0.018..0.027 rows=24 loops=1)

  • Index Cond: ((location = 19) AND (measure = 6) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts < '2020-01-03 00:00:00+00'::timestamp with time zone))
Planning time : 0.722 ms
Execution time : 2.345 ms