explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VP8N

Settings
# exclusive inclusive rows x rows loops node
1. 1.252 4.743 ↑ 1.0 1 1

Aggregate (cost=2,779.77..2,779.78 rows=1 width=32) (actual time=4.743..4.743 rows=1 loops=1)

2. 2.336 3.491 ↓ 6.2 659 1

Append (cost=0.00..2,777.65 rows=106 width=33) (actual time=0.033..3.491 rows=659 loops=1)

3. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on measurements m (cost=0.00..0.00 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((deviceid)::text = 'SPENDMAPP_61076'::text) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
4. 0.023 0.038 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_195_chunk m_1 (cost=4.17..11.31 rows=1 width=32) (actual time=0.023..0.038 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
5. 0.015 0.015 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_195_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.015..0.015 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
6. 0.017 0.038 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_43_chunk m_2 (cost=4.56..97.79 rows=1 width=31) (actual time=0.025..0.038 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
7. 0.021 0.021 ↑ 1.8 21 1

Bitmap Index Scan on _hyper_1_43_chunk_measurements_deviceid_idx (cost=0.00..4.56 rows=37 width=0) (actual time=0.020..0.021 rows=21 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
8. 0.015 0.015 ↓ 0.0 0 1

Index Scan using _hyper_1_106_chunk_measurements_deviceid_idx on _hyper_1_106_chunk m_3 (cost=0.29..8.31 rows=1 width=31) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
9. 0.017 0.027 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_171_chunk m_4 (cost=4.17..11.31 rows=1 width=32) (actual time=0.013..0.027 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
10. 0.010 0.010 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_171_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.009..0.010 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
11. 0.020 0.029 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_227_chunk m_5 (cost=4.17..11.31 rows=1 width=32) (actual time=0.015..0.029 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
12. 0.009 0.009 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_227_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.009..0.009 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
13. 0.017 0.025 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_191_chunk m_6 (cost=4.17..11.31 rows=1 width=32) (actual time=0.012..0.025 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
14. 0.008 0.008 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_191_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.008..0.008 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
15. 0.030 0.030 ↓ 7.0 7 1

Index Scan using _hyper_1_8_chunk_measurements_deviceid_idx on _hyper_1_8_chunk m_7 (cost=0.29..8.32 rows=1 width=37) (actual time=0.024..0.030 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
16. 0.019 0.027 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_220_chunk m_8 (cost=4.17..11.31 rows=1 width=32) (actual time=0.013..0.027 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
17. 0.008 0.008 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_220_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.008..0.008 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
18. 0.037 0.037 ↓ 7.0 7 1

Index Scan using _hyper_1_11_chunk_measurements_deviceid_idx on _hyper_1_11_chunk m_9 (cost=0.29..6.68 rows=1 width=37) (actual time=0.032..0.037 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
19. 0.018 0.026 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_194_chunk m_10 (cost=4.17..11.31 rows=1 width=32) (actual time=0.012..0.026 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
20. 0.008 0.008 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_194_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.008..0.008 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
21. 0.018 0.027 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_228_chunk m_11 (cost=4.17..11.31 rows=1 width=32) (actual time=0.012..0.027 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
22. 0.009 0.009 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_228_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.009..0.009 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
23. 0.020 0.028 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_190_chunk m_12 (cost=4.17..11.31 rows=1 width=32) (actual time=0.014..0.028 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
24. 0.008 0.008 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_190_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.008..0.008 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
25. 0.018 0.031 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_179_chunk m_13 (cost=4.17..11.31 rows=1 width=32) (actual time=0.017..0.031 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
26. 0.013 0.013 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_179_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.012..0.013 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
27. 0.095 0.095 ↓ 7.0 7 1

Index Scan using _hyper_1_16_chunk_measurements_deviceid_idx on _hyper_1_16_chunk m_14 (cost=0.29..8.32 rows=1 width=29) (actual time=0.091..0.095 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
28. 0.012 0.012 ↓ 0.0 0 1

Index Scan using _hyper_1_132_chunk_measurements_deviceid_idx on _hyper_1_132_chunk m_15 (cost=0.29..8.32 rows=1 width=47) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
29. 0.019 0.031 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_209_chunk m_16 (cost=4.17..11.31 rows=1 width=32) (actual time=0.017..0.031 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
30. 0.012 0.012 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_209_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.012..0.012 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
31. 0.094 0.094 ↓ 7.0 7 1

Index Scan using _hyper_1_3_chunk_measurements_deviceid_idx on _hyper_1_3_chunk m_17 (cost=0.29..8.32 rows=1 width=30) (actual time=0.090..0.094 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
32. 0.019 0.033 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_201_chunk m_18 (cost=4.17..11.31 rows=1 width=32) (actual time=0.019..0.033 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
33. 0.014 0.014 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_201_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.014..0.014 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
34. 0.017 0.026 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_176_chunk m_19 (cost=4.17..11.31 rows=1 width=32) (actual time=0.012..0.026 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
35. 0.009 0.009 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_176_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.008..0.009 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
36. 0.016 0.027 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_208_chunk m_20 (cost=4.17..11.31 rows=1 width=32) (actual time=0.015..0.027 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
37. 0.011 0.011 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_208_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.011..0.011 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
38. 0.000 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_110_chunk m_21 (cost=5.75..446.61 rows=1 width=34) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
39. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_110_chunk_measurements_deviceid_idx (cost=0.00..5.75 rows=194 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
40. 0.018 0.031 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_175_chunk m_22 (cost=4.17..11.31 rows=1 width=32) (actual time=0.017..0.031 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
41. 0.013 0.013 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_175_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.013..0.013 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
42. 0.019 0.030 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_178_chunk m_23 (cost=4.17..11.31 rows=1 width=32) (actual time=0.016..0.030 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
43. 0.011 0.011 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_178_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.011..0.011 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
44. 0.017 0.030 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_169_chunk m_24 (cost=4.17..11.31 rows=1 width=32) (actual time=0.017..0.030 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
45. 0.013 0.013 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_169_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.013..0.013 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
46. 0.020 0.028 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_211_chunk m_25 (cost=4.17..11.31 rows=1 width=32) (actual time=0.014..0.028 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
47. 0.008 0.008 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_211_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.008..0.008 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
48. 0.032 0.032 ↓ 7.0 7 1

Index Scan using _hyper_1_14_chunk_measurements_deviceid_idx on _hyper_1_14_chunk m_26 (cost=0.29..8.03 rows=1 width=28) (actual time=0.027..0.032 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
49. 0.027 0.027 ↓ 7.0 7 1

Index Scan using _hyper_1_46_chunk_measurements_deviceid_idx on _hyper_1_46_chunk m_27 (cost=0.29..8.31 rows=1 width=30) (actual time=0.022..0.027 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
50. 0.030 0.030 ↓ 7.0 7 1

Index Scan using _hyper_1_48_chunk_measurements_deviceid_idx on _hyper_1_48_chunk m_28 (cost=0.29..8.27 rows=1 width=30) (actual time=0.026..0.030 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
51. 0.029 0.029 ↓ 7.0 7 1

Index Scan using _hyper_1_17_chunk_measurements_deviceid_idx on _hyper_1_17_chunk m_29 (cost=0.28..8.29 rows=1 width=37) (actual time=0.025..0.029 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
52. 0.017 0.026 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_174_chunk m_30 (cost=4.17..11.31 rows=1 width=32) (actual time=0.013..0.026 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
53. 0.009 0.009 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_174_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.009..0.009 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
54. 0.017 0.029 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_204_chunk m_31 (cost=4.17..11.31 rows=1 width=32) (actual time=0.015..0.029 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
  • Heap Blocks: exact=3
55. 0.012 0.012 ↓ 9.3 28 1

Bitmap Index Scan on _hyper_1_204_chunk_measurements_deviceid_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.012..0.012 rows=28 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
56. 0.029 0.029 ↓ 7.0 7 1

Index Scan using _hyper_1_15_chunk_measurements_deviceid_idx on _hyper_1_15_chunk m_32 (cost=0.29..8.32 rows=1 width=30) (actual time=0.025..0.029 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
57. 0.032 0.032 ↓ 7.0 7 1

Index Scan using _hyper_1_77_chunk_measurements_deviceid_idx on _hyper_1_77_chunk m_33 (cost=0.29..8.32 rows=1 width=30) (actual time=0.027..0.032 rows=7 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
  • Rows Removed by Filter: 14
58. 0.012 0.012 ↓ 0.0 0 1

Index Scan using _hyper_1_142_chunk_measurements_deviceid_idx on _hyper_1_142_chunk m_34 (cost=0.29..8.32 rows=1 width=49) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)
  • Filter: (("time" >= '2017-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ("time" <= '2019-10-10 10:13:19.275+10:30'::timestamp with time zone) AND ((tags ->> 'type'::text) = 'total_local_spending'::text))
59. 0.075 0.075 ↓ 7.0 7 1

Bitmap Heap Scan on _hyper_1_223_chunk m_35 (cost=4.17..11.31 rows=1 width=32) (actual time=0.060..0.075 rows=7 loops=1)

  • Recheck Cond: ((deviceid)::text = 'SPENDMAPP_61076'::text)