explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D6sq

Settings
# exclusive inclusive rows x rows loops node
1. 13.697 23.320 ↑ 1.0 793 1

Append (cost=0.00..2,353.01 rows=794 width=83) (actual time=0.097..23.320 rows=793 loops=1)

2. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on measurement (cost=0.00..0.00 rows=1 width=104) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: ((ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone) AND (location = 1) AND (measure = 1))
3. 0.346 0.374 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_01 (cost=4.65..71.05 rows=24 width=83) (actual time=0.051..0.374 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_01_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.028..0.028 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
5. 0.317 0.336 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_02 (cost=4.65..71.05 rows=24 width=83) (actual time=0.040..0.336 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_02_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.019..0.019 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
7. 0.254 0.285 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_03 (cost=4.65..71.05 rows=24 width=83) (actual time=0.051..0.285 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_03_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.031..0.031 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
9. 0.322 0.353 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_04 (cost=4.65..71.05 rows=24 width=83) (actual time=0.051..0.353 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_04_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.031..0.031 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
11. 0.242 0.266 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_05 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.266 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_05_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
13. 0.322 0.345 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_06 (cost=4.65..71.05 rows=24 width=83) (actual time=0.042..0.345 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_06_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.023..0.023 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
15. 0.240 0.264 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_07 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.264 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_07_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
17. 0.248 0.271 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_08 (cost=4.65..71.05 rows=24 width=83) (actual time=0.042..0.271 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_08_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.023..0.023 rows=24 loops=1)

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

Bitmap Heap Scan on datamart_measurement_2020_01_09 (cost=4.65..71.05 rows=24 width=83) (actual time=0.120..0.343 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_09_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.025..0.025 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
21. 0.246 0.269 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_10 (cost=4.65..71.05 rows=24 width=83) (actual time=0.042..0.269 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_10_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.023..0.023 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
23. 0.249 0.276 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_11 (cost=4.65..71.05 rows=24 width=83) (actual time=0.048..0.276 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_11_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.027..0.027 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
25. 0.249 0.275 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_12 (cost=4.65..71.05 rows=24 width=83) (actual time=0.046..0.275 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_12_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.026..0.026 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
27. 0.245 0.269 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_13 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.269 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_13_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
29. 0.371 0.404 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_14 (cost=4.65..71.05 rows=24 width=83) (actual time=0.052..0.404 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_14_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.033..0.033 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
31. 0.245 0.271 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_15 (cost=4.65..71.05 rows=24 width=83) (actual time=0.045..0.271 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_15_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.026..0.026 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
33. 0.319 0.345 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_16 (cost=4.65..71.05 rows=24 width=83) (actual time=0.046..0.345 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_16_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.026..0.026 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
35. 0.325 0.348 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_17 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.348 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_17_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.023..0.023 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
37. 0.243 0.266 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_18 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.266 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_18_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.023..0.023 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
39. 0.241 0.266 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_19 (cost=4.65..71.05 rows=24 width=83) (actual time=0.044..0.266 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_19_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.025..0.025 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
41. 0.238 0.261 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_20 (cost=4.65..71.05 rows=24 width=83) (actual time=0.042..0.261 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_20_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.023..0.023 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
43. 0.242 0.266 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_21 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.266 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_21_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
45. 0.242 0.266 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_22 (cost=4.65..71.05 rows=24 width=83) (actual time=0.044..0.266 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_22_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
47. 0.244 0.268 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_23 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.268 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_23_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
49. 0.244 0.269 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_24 (cost=4.65..71.05 rows=24 width=83) (actual time=0.044..0.269 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_24_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.025..0.025 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
51. 0.244 0.273 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_25 (cost=4.65..71.05 rows=24 width=83) (actual time=0.048..0.273 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_25_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.029..0.029 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
53. 0.241 0.265 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_26 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.265 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_26_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
55. 0.241 0.264 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_27 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.264 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_27_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.023..0.023 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
57. 0.242 0.266 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_28 (cost=4.65..71.05 rows=24 width=83) (actual time=0.044..0.266 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_28_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
59. 0.245 0.270 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_29 (cost=4.65..71.05 rows=24 width=83) (actual time=0.045..0.270 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_29_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.025..0.025 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
61. 0.249 0.273 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_30 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.273 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_30_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
63. 0.245 0.270 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_01_31 (cost=4.65..71.05 rows=24 width=83) (actual time=0.045..0.270 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_01_31_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.025..0.025 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
65. 0.246 0.271 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_02_01 (cost=4.65..71.05 rows=24 width=83) (actual time=0.045..0.271 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_02_01_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.025..0.025 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
67. 0.246 0.270 ↑ 1.0 24 1

Bitmap Heap Scan on datamart_measurement_2020_02_02 (cost=4.65..71.05 rows=24 width=83) (actual time=0.043..0.270 rows=24 loops=1)

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

Bitmap Index Scan on datamart_measurement_2020_02_02_location_measure_ts_ts1_idx (cost=0.00..4.65 rows=24 width=0) (actual time=0.024..0.024 rows=24 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
69. 0.033 0.033 ↑ 1.0 1 1

Index Scan using datamart_measurement_2020_02_03_location_measure_ts_ts1_idx on datamart_measurement_2020_02_03 (cost=0.29..8.31 rows=1 width=83) (actual time=0.025..0.033 rows=1 loops=1)

  • Index Cond: ((location = 1) AND (measure = 1) AND (ts >= '2020-01-01 00:00:00+00'::timestamp with time zone) AND (ts <= '2020-02-03 00:00:00+00'::timestamp with time zone))
Planning time : 14.832 ms
Execution time : 30.664 ms