explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bsbF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2,353.01 rows=794 width=83) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
4. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
6. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
8. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
10. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
12. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
14. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
16. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
18. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
20. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
22. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
24. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
26. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
28. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
30. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
32. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
34. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
36. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
38. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
40. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
42. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
44. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
46. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
48. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
50. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
52. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
54. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
56. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
58. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
60. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
62. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
64. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
66. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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

  • 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))
68. 0.000 0.000 ↓ 0.0

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

  • 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.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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))