explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gMJ3

Settings
# exclusive inclusive rows x rows loops node
1. 6.929 6.929 ↓ 445.0 445 1

CTE Scan on observations (cost=2,401.38..2,406.38 rows=1 width=102) (actual time=6.857..6.929 rows=445 loops=1)

  • Filter: ((t >= $1) AND (t <= $2))
2.          

CTE observations

3. 0.741 6.523 ↓ 2.2 445 1

HashAggregate (cost=2,389.36..2,392.36 rows=200 width=93) (actual time=6.371..6.523 rows=445 loops=1)

  • Group Key: date_trunc('month'::text, feed_obs.""time""), feed_obs.fid, feed_obs.lat, feed_obs.lon, feed_obs.z
4. 0.200 5.782 ↑ 1.6 469 1

Result (cost=0.00..2,358.88 rows=762 width=57) (actual time=0.084..5.782 rows=469 loops=1)

5. 3.352 5.582 ↑ 1.6 469 1

Append (cost=0.00..2,349.36 rows=762 width=57) (actual time=0.077..5.582 rows=469 loops=1)

6. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
7. 0.024 0.024 ↓ 0.0 0 1

Index Scan using _hyper_1_1074_chunk_feed_obs_fid_time_idx on _hyper_1_1074_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
8. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1106_chunk_feed_obs_fid_time_idx on _hyper_1_1106_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
9. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_985_chunk_feed_obs_fid_time_idx on _hyper_1_985_chunk (cost=0.15..6.83 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
10. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_866_chunk_feed_obs_fid_time_idx on _hyper_1_866_chunk (cost=0.15..8.03 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
11. 0.024 0.024 ↑ 1.0 2 1

Seq Scan on _hyper_1_483_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.019..0.024 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
12. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_887_chunk_feed_obs_fid_time_idx on _hyper_1_887_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
13. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_601_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
14. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_971_chunk_feed_obs_fid_time_idx on _hyper_1_971_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
15. 0.020 0.020 ↑ 1.0 2 1

Seq Scan on _hyper_1_647_chunk (cost=0.00..3.40 rows=2 width=57) (actual time=0.012..0.020 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
16. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_497_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
17. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_881_chunk_feed_obs_fid_time_idx on _hyper_1_881_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
18. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_1070_chunk_feed_obs_fid_time_idx on _hyper_1_1070_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
19. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_930_chunk_feed_obs_fid_time_idx on _hyper_1_930_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
20. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on _hyper_1_318_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.012..0.017 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
21. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_903_chunk_feed_obs_fid_time_idx on _hyper_1_903_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
22. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_452_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
23. 0.004 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1080_chunk (cost=4.17..11.30 rows=3 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: (fid = 1000258)
  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
24. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1080_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (fid = 1000258)
25. 0.010 0.010 ↓ 0.0 0 1

Index Scan using _hyper_1_855_chunk_feed_obs_fid_time_idx on _hyper_1_855_chunk (cost=0.15..8.02 rows=1 width=55) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
26. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_496_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.010..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
27. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_877_chunk_feed_obs_fid_time_idx on _hyper_1_877_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
28. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_455_chunk (cost=0.00..1.42 rows=2 width=57) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
29. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1138_chunk_feed_obs_fid_time_idx on _hyper_1_1138_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
30. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_470_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
31. 0.010 0.010 ↓ 0.0 0 1

Index Scan using _hyper_1_876_chunk_feed_obs_fid_time_idx on _hyper_1_876_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
32. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_571_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
33. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_959_chunk_feed_obs_fid_time_idx on _hyper_1_959_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
34. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_1087_chunk_feed_obs_fid_time_idx on _hyper_1_1087_chunk (cost=0.15..8.01 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
35. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_630_chunk (cost=0.00..1.42 rows=2 width=57) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
36. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_1101_chunk_feed_obs_fid_time_idx on _hyper_1_1101_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
37. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_577_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
38. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_606_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
39. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_850_chunk_feed_obs_fid_time_idx on _hyper_1_850_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
40. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_599_chunk (cost=0.00..1.42 rows=2 width=57) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
41. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1083_chunk_feed_obs_fid_time_idx on _hyper_1_1083_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
42. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_622_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
43. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_856_chunk (cost=4.17..9.52 rows=2 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (fid = 1000258)
  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
44. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_856_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.17 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000258)
45. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1128_chunk_feed_obs_fid_time_idx on _hyper_1_1128_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
46. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1005_chunk_feed_obs_fid_time_idx on _hyper_1_1005_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
47. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_967_chunk_feed_obs_fid_time_idx on _hyper_1_967_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
48. 0.012 0.012 ↓ 0.0 0 1

Index Scan using _hyper_1_1124_chunk_feed_obs_fid_time_idx on _hyper_1_1124_chunk (cost=0.15..6.13 rows=1 width=55) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
49. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1099_chunk_feed_obs_fid_time_idx on _hyper_1_1099_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
50. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1002_chunk (cost=4.17..9.52 rows=2 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (fid = 1000258)
  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
51. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1002_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.17 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000258)
52. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_872_chunk_feed_obs_fid_time_idx on _hyper_1_872_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
53. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_921_chunk_feed_obs_fid_time_idx on _hyper_1_921_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
54. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on _hyper_1_399_chunk (cost=0.00..1.31 rows=2 width=56) (actual time=0.012..0.017 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 37
55. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1076_chunk_feed_obs_fid_time_idx on _hyper_1_1076_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
56. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_852_chunk_feed_obs_fid_time_idx on _hyper_1_852_chunk (cost=0.15..8.06 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
57. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1143_chunk_feed_obs_fid_time_idx on _hyper_1_1143_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
58. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_585_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
59. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_437_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
60. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_871_chunk_feed_obs_fid_time_idx on _hyper_1_871_chunk (cost=0.15..7.96 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
61. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_514_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
62. 0.018 0.018 ↑ 1.0 2 1

Seq Scan on _hyper_1_518_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.015..0.018 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
63. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_620_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
64. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_623_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.012..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
65. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_1092_chunk_feed_obs_fid_time_idx on _hyper_1_1092_chunk (cost=0.15..8.02 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
66. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_531_chunk (cost=0.00..1.42 rows=2 width=57) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
67. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_454_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
68. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_939_chunk_feed_obs_fid_time_idx on _hyper_1_939_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
69. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1114_chunk_feed_obs_fid_time_idx on _hyper_1_1114_chunk (cost=0.15..5.99 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
70. 0.018 0.018 ↑ 1.0 2 1

Seq Scan on _hyper_1_486_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.013..0.018 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
71. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_1133_chunk_feed_obs_fid_time_idx on _hyper_1_1133_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
72. 0.012 0.012 ↓ 0.0 0 1

Index Scan using _hyper_1_847_chunk_feed_obs_fid_time_idx on _hyper_1_847_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
73. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_439_chunk (cost=0.00..1.35 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 39
74. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_1069_chunk_feed_obs_fid_time_idx on _hyper_1_1069_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
75. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1130_chunk_feed_obs_fid_time_idx on _hyper_1_1130_chunk (cost=0.15..6.05 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
76. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_988_chunk_feed_obs_fid_time_idx on _hyper_1_988_chunk (cost=0.15..6.67 rows=1 width=55) (actual time=0.005..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
77. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_560_chunk (cost=0.00..1.40 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
78. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_991_chunk_feed_obs_fid_time_idx on _hyper_1_991_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
79. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on _hyper_1_438_chunk (cost=0.00..1.33 rows=1 width=57) (actual time=0.010..0.014 rows=1 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 39
80. 0.010 0.010 ↓ 0.0 0 1

Index Scan using _hyper_1_957_chunk_feed_obs_fid_time_idx on _hyper_1_957_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
81. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_996_chunk_feed_obs_fid_time_idx on _hyper_1_996_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
82. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_405_chunk (cost=0.00..1.28 rows=2 width=57) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 35
83. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_940_chunk_feed_obs_fid_time_idx on _hyper_1_940_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
84. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1105_chunk_feed_obs_fid_time_idx on _hyper_1_1105_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
85. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_487_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.010..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
86. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1110_chunk_feed_obs_fid_time_idx on _hyper_1_1110_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
87. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_910_chunk_feed_obs_fid_time_idx on _hyper_1_910_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
88. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_553_chunk (cost=0.00..1.31 rows=2 width=57) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 37
89. 0.010 0.010 ↓ 0.0 0 1

Index Scan using _hyper_1_1151_chunk_feed_obs_fid_time_idx on _hyper_1_1151_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
90. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1096_chunk_feed_obs_fid_time_idx on _hyper_1_1096_chunk (cost=0.15..7.99 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
91. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_632_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
92. 0.011 0.011 ↓ 0.0 0 1

Index Scan using _hyper_1_969_chunk_feed_obs_fid_time_idx on _hyper_1_969_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
93. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on _hyper_1_409_chunk (cost=0.00..1.31 rows=2 width=57) (actual time=0.013..0.017 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 37
94. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_883_chunk_feed_obs_fid_time_idx on _hyper_1_883_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
95. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_414_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
96. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1116_chunk_feed_obs_fid_time_idx on _hyper_1_1116_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
97. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_449_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
98. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_1146_chunk_feed_obs_fid_time_idx on _hyper_1_1146_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
99. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_446_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
100. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_942_chunk_feed_obs_fid_time_idx on _hyper_1_942_chunk (cost=0.15..7.98 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
101. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_986_chunk_feed_obs_fid_time_idx on _hyper_1_986_chunk (cost=0.15..6.18 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
102. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on _hyper_1_417_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.013..0.017 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
103. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_434_chunk (cost=0.00..1.35 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 39
104. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_899_chunk_feed_obs_fid_time_idx on _hyper_1_899_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
105. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1108_chunk_feed_obs_fid_time_idx on _hyper_1_1108_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
106. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_950_chunk_feed_obs_fid_time_idx on _hyper_1_950_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
107. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1115_chunk_feed_obs_fid_time_idx on _hyper_1_1115_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
108. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1120_chunk_feed_obs_fid_time_idx on _hyper_1_1120_chunk (cost=0.15..6.07 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
109. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_587_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
110. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_605_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
111. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_604_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
112. 0.011 0.011 ↓ 0.0 0 1

Index Scan using _hyper_1_1071_chunk_feed_obs_fid_time_idx on _hyper_1_1071_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
113. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1093_chunk_feed_obs_fid_time_idx on _hyper_1_1093_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
114. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_961_chunk_feed_obs_fid_time_idx on _hyper_1_961_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
115. 0.019 0.019 ↑ 1.0 2 1

Seq Scan on _hyper_1_641_chunk (cost=0.00..3.60 rows=2 width=56) (actual time=0.012..0.019 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 39
116. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_1067_chunk_feed_obs_fid_time_idx on _hyper_1_1067_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
117. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1103_chunk_feed_obs_fid_time_idx on _hyper_1_1103_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
118. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on _hyper_1_639_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.013..0.017 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
119. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_447_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
120. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_1009_chunk_feed_obs_fid_time_idx on _hyper_1_1009_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
121. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_555_chunk (cost=0.00..1.39 rows=2 width=57) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
122. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1073_chunk_feed_obs_fid_time_idx on _hyper_1_1073_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
123. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_554_chunk (cost=0.00..1.31 rows=2 width=57) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 37
124. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_558_chunk (cost=0.00..1.39 rows=2 width=57) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
125. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_1100_chunk_feed_obs_fid_time_idx on _hyper_1_1100_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
126. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1142_chunk_feed_obs_fid_time_idx on _hyper_1_1142_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
127. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_934_chunk_feed_obs_fid_time_idx on _hyper_1_934_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
128. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_951_chunk_feed_obs_fid_time_idx on _hyper_1_951_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
129. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1020_chunk_feed_obs_fid_time_idx on _hyper_1_1020_chunk (cost=0.15..6.06 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
130. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_1065_chunk_feed_obs_fid_time_idx on _hyper_1_1065_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
131. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_511_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
132. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_430_chunk (cost=0.00..1.35 rows=2 width=57) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 39
133. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_523_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
134. 0.023 0.023 ↑ 1.0 2 1

Seq Scan on _hyper_1_506_chunk (cost=0.00..1.35 rows=2 width=57) (actual time=0.019..0.023 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 39
135. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_964_chunk_feed_obs_fid_time_idx on _hyper_1_964_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
136. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_882_chunk_feed_obs_fid_time_idx on _hyper_1_882_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
137. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_922_chunk_feed_obs_fid_time_idx on _hyper_1_922_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
138. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_968_chunk_feed_obs_fid_time_idx on _hyper_1_968_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
139. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_508_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.010..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
140. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_520_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
141. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_526_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
142. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_489_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 40
143. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on _hyper_1_559_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.013..0.017 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
144. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1072_chunk_feed_obs_fid_time_idx on _hyper_1_1072_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
145. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1008_chunk_feed_obs_fid_time_idx on _hyper_1_1008_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
146. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_974_chunk_feed_obs_fid_time_idx on _hyper_1_974_chunk (cost=0.15..7.74 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
147. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_457_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
148. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_849_chunk_feed_obs_fid_time_idx on _hyper_1_849_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
149. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_471_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
150. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_464_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
151. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1125_chunk (cost=4.18..12.66 rows=4 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (fid = 1000258)
  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
152. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1125_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.18 rows=4 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (fid = 1000258)
153. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1019_chunk_feed_obs_fid_time_idx on _hyper_1_1019_chunk (cost=0.15..6.02 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
154. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_465_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.010..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
155. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_958_chunk_feed_obs_fid_time_idx on _hyper_1_958_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
156. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1004_chunk_feed_obs_fid_time_idx on _hyper_1_1004_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
157. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_325_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
158. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_947_chunk_feed_obs_fid_time_idx on _hyper_1_947_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
159. 0.006 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1021_chunk (cost=4.17..9.52 rows=2 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: (fid = 1000258)
  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
160. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1021_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.17 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000258)
161. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on _hyper_1_563_chunk (cost=0.00..1.39 rows=1 width=58) (actual time=0.012..0.015 rows=1 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
162. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_1066_chunk_feed_obs_fid_time_idx on _hyper_1_1066_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
163. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_567_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
164. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_980_chunk_feed_obs_fid_time_idx on _hyper_1_980_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
165. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_477_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
166. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_479_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
167. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_861_chunk_feed_obs_fid_time_idx on _hyper_1_861_chunk (cost=0.15..7.99 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
168. 0.015 0.015 ↓ 2.0 2 1

Seq Scan on _hyper_1_640_chunk (cost=0.00..1.39 rows=1 width=56) (actual time=0.012..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
169. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_504_chunk (cost=0.00..1.35 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 39
170. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_955_chunk_feed_obs_fid_time_idx on _hyper_1_955_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
171. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1075_chunk_feed_obs_fid_time_idx on _hyper_1_1075_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
172. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on _hyper_1_512_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.013..0.017 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
173. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_513_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
174. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_586_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.010..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
175. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_973_chunk_feed_obs_fid_time_idx on _hyper_1_973_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
176. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1003_chunk_feed_obs_fid_time_idx on _hyper_1_1003_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
177. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_633_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.013..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
178. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1104_chunk_feed_obs_fid_time_idx on _hyper_1_1104_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
179. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_900_chunk_feed_obs_fid_time_idx on _hyper_1_900_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
180. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1079_chunk_feed_obs_fid_time_idx on _hyper_1_1079_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
181. 0.018 0.018 ↑ 1.0 2 1

Seq Scan on _hyper_1_442_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.013..0.018 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
182. 0.013 0.013 ↓ 0.0 0 1

Index Scan using _hyper_1_1085_chunk_feed_obs_fid_time_idx on _hyper_1_1085_chunk (cost=0.15..7.99 rows=1 width=55) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
183. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1132_chunk_feed_obs_fid_time_idx on _hyper_1_1132_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
184. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_914_chunk_feed_obs_fid_time_idx on _hyper_1_914_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
185. 0.014 0.014 ↑ 1.0 2 1

Seq Scan on _hyper_1_406_chunk (cost=0.00..1.25 rows=2 width=57) (actual time=0.011..0.014 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 33
186. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on _hyper_1_524_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.013..0.017 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
187. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_460_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
188. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1129_chunk_feed_obs_fid_time_idx on _hyper_1_1129_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
189. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_1098_chunk_feed_obs_fid_time_idx on _hyper_1_1098_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
190. 0.018 0.018 ↑ 1.0 2 1

Seq Scan on _hyper_1_529_chunk (cost=0.00..1.44 rows=2 width=57) (actual time=0.013..0.018 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 44
191. 0.020 0.020 ↑ 1.0 2 1

Seq Scan on _hyper_1_644_chunk (cost=0.00..4.63 rows=2 width=57) (actual time=0.012..0.020 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
192. 0.015 0.015 ↑ 1.0 1 1

Seq Scan on _hyper_1_441_chunk (cost=0.00..1.35 rows=1 width=57) (actual time=0.011..0.015 rows=1 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 40
193. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_949_chunk_feed_obs_fid_time_idx on _hyper_1_949_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
194. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_505_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
195. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_591_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
196. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_557_chunk (cost=0.00..1.37 rows=2 width=57) (actual time=0.012..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 40
197. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_521_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.010..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
198. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_870_chunk_feed_obs_fid_time_idx on _hyper_1_870_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
199. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_428_chunk (cost=0.00..1.39 rows=2 width=58) (actual time=0.011..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 41
200. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_1117_chunk_feed_obs_fid_time_idx on _hyper_1_1117_chunk (cost=0.15..5.96 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000258) AND ("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone))
201. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on _hyper_1_324_chunk (cost=0.00..1.19 rows=1 width=57) (actual time=0.011..0.014 rows=1 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 31
202. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_450_chunk (cost=0.00..1.42 rows=2 width=58) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 43
203. 0.017 0.017 ↑ 1.0 2 1

Seq Scan on _hyper_1_502_chunk (cost=0.00..1.35 rows=2 width=58) (actual time=0.013..0.017 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 39
204. 0.016 0.016 ↑ 1.0 2 1

Seq Scan on _hyper_1_481_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.011..0.016 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42
205. 0.015 0.015 ↑ 1.0 2 1

Seq Scan on _hyper_1_614_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.012..0.015 rows=2 loops=1)

  • Filter: (("time" >= '2000-01-12 18:25:30'::timestamp without time zone) AND ("time" <= '2009-10-12 18:25:30'::timestamp without time zone) AND (fid = 1000258))
  • Rows Removed by Filter: 42