explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SXZo

Settings
# exclusive inclusive rows x rows loops node
1. 49.313 64.144 ↓ 39.0 239,752 1

Custom Scan (GapFill) (cost=29,007.64..29,023.02 rows=6,154 width=91) (actual time=14.800..64.144 rows=239,752 loops=1)

2. 1.162 14.831 ↑ 9.3 664 1

Sort (cost=29,007.64..29,023.02 rows=6,154 width=91) (actual time=14.795..14.831 rows=664 loops=1)

  • Sort Key: feed_obs.lat, feed_obs.lon, feed_obs.z, (time_bucket_gapfill('01:00:00'::interval, feed_obs."time", '1992-01-01 08:00:00'::timestamp without time zone, '2019-05-08 23:46:12'::timestamp without time zone))
  • Sort Method: quicksort Memory: 118kB
3. 1.751 13.669 ↑ 9.3 664 1

HashAggregate (cost=28,528.02..28,620.33 rows=6,154 width=91) (actual time=13.375..13.669 rows=664 loops=1)

  • Group Key: time_bucket_gapfill('01:00:00'::interval, feed_obs."time", '1992-01-01 08:00:00'::timestamp without time zone, '2019-05-08 23:46:12'::timestamp without time zone), feed_obs.fid, feed_obs.lat, feed_obs.lon, feed_obs.z
4. 0.358 11.918 ↑ 29.4 2,095 1

Result (cost=0.00..26,066.30 rows=61,543 width=55) (actual time=6.068..11.918 rows=2,095 loops=1)

5. 9.129 11.560 ↑ 29.4 2,095 1

Append (cost=0.00..25,297.01 rows=61,543 width=55) (actual time=6.066..11.560 rows=2,095 loops=1)

6. 0.011 0.011 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
7. 0.004 0.021 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1074_chunk (cost=5.48..17.30 rows=104 width=55) (actual time=0.021..0.021 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
8. 0.017 0.017 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1074_chunk_feed_obs_fid_time_idx (cost=0.00..5.45 rows=104 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
9. 0.012 0.012 ↓ 0.0 0 1

Index Scan using _hyper_1_251_chunk_feed_obs_fid_time_idx on _hyper_1_251_chunk (cost=0.29..6.17 rows=1 width=55) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
10. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_887_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
11. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_887_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
12. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_264_chunk_feed_obs_fid_time_idx on _hyper_1_264_chunk (cost=0.29..6.17 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
13. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1070_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
14. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1070_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
15. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3871_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
16. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3871_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
17. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1080_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
18. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1080_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
19. 0.020 0.020 ↓ 0.0 0 1

Seq Scan on _hyper_1_496_chunk (cost=0.00..1.39 rows=1 width=58) (actual time=0.020..0.020 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
20. 0.011 0.011 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
21. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1087_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
22. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1087_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
23. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_630_chunk (cost=0.00..1.42 rows=1 width=57) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
24. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1101_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
25. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1101_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
26. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_209_chunk_feed_obs_fid_time_idx on _hyper_1_209_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
27. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_276_chunk_feed_obs_fid_time_idx on _hyper_1_276_chunk (cost=0.28..8.30 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
28. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 23
29. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_850_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
30. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_850_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
31. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
32. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3903_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
33. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3903_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
34. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1083_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
35. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1083_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
36. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_856_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
37. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_856_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
38. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3805_chunk (cost=5.44..17.21 rows=101 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
39. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3805_chunk_feed_obs_fid_time_idx (cost=0.00..5.41 rows=101 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
40. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3795_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
41. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3795_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
42. 0.011 0.011 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 11
43. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1124_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
44. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1124_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
45. 0.004 0.004 ↓ 0.0 0 1

Index Scan using _hyper_1_3995_chunk_feed_obs_fid_time_idx on _hyper_1_3995_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
46. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_872_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
47. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_872_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
48. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_151_chunk_feed_obs_fid_time_idx on _hyper_1_151_chunk (cost=0.42..8.44 rows=1 width=58) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
49. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_921_chunk (cost=5.40..17.11 rows=98 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
50. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_921_chunk_feed_obs_fid_time_idx (cost=0.00..5.38 rows=98 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
51. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_253_chunk_feed_obs_fid_time_idx on _hyper_1_253_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
52. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_119_chunk (cost=5.57..17.51 rows=111 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
53. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_119_chunk_feed_obs_fid_time_idx (cost=0.00..5.54 rows=111 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
54. 0.004 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_270_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
55. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_270_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
56. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3851_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
57. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3851_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
58. 0.015 0.015 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
59. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3828_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
60. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3828_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
61. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_101_chunk_feed_obs_fid_time_idx on _hyper_1_101_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
62. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_339_chunk (cost=0.00..1.28 rows=1 width=57) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
63. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3937_chunk (cost=4.47..15.19 rows=41 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
64. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3937_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.46 rows=41 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
65. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_847_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
66. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_847_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
67. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_82_chunk_feed_obs_fid_time_idx on _hyper_1_82_chunk (cost=0.15..7.61 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
68. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3949_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
69. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3949_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
70. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1043_chunk (cost=6.09..18.75 rows=152 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
71. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1043_chunk_feed_obs_fid_time_idx (cost=0.00..6.05 rows=152 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
72. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1048_chunk (cost=6.11..18.81 rows=154 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
73. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1048_chunk_feed_obs_fid_time_idx (cost=0.00..6.08 rows=154 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
74. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_25_chunk_feed_obs_fid_time_idx on _hyper_1_25_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
75. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_3704_chunk_feed_obs_fid_time_idx on _hyper_1_3704_chunk (cost=0.15..7.51 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
76. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_359_chunk (cost=0.00..1.28 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
77. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1060_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
78. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1060_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
79. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_26_chunk_feed_obs_fid_time_idx on _hyper_1_26_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
80. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_213_chunk_feed_obs_fid_time_idx on _hyper_1_213_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
81. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3808_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
82. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3808_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
83. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_3989_chunk_feed_obs_fid_time_idx on _hyper_1_3989_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
84. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_3715_chunk_feed_obs_fid_time_idx on _hyper_1_3715_chunk (cost=0.15..6.87 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
85. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3895_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
86. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3895_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
87. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_136_chunk_feed_obs_fid_time_idx on _hyper_1_136_chunk (cost=0.29..6.06 rows=1 width=56) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
88. 0.004 0.004 ↓ 0.0 0 1

Index Scan using _hyper_1_196_chunk_feed_obs_fid_time_idx on _hyper_1_196_chunk (cost=0.14..7.32 rows=1 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
89. 0.011 0.011 ↓ 0.0 0 1

Index Scan using _hyper_1_218_chunk_feed_obs_fid_time_idx on _hyper_1_218_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
90. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_373_chunk (cost=0.00..1.28 rows=1 width=57) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
91. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3911_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
92. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3911_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
93. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_969_chunk (cost=4.13..8.15 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
94. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_969_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.13 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
95. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_230_chunk_feed_obs_fid_time_idx on _hyper_1_230_chunk (cost=0.29..6.18 rows=1 width=55) (actual time=0.004..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
96. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
97. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1116_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
98. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1116_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
99. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3781_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
100. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3781_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
101. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_449_chunk (cost=0.00..1.40 rows=1 width=57) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 23
102. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1146_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
103. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1146_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
104. 0.025 0.025 ↓ 0.0 0 1

Seq Scan on _hyper_1_667_chunk (cost=0.00..8.23 rows=1 width=57) (actual time=0.025..0.025 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 13
105. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_899_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
106. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_899_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
107. 0.004 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1108_chunk (cost=5.73..17.90 rows=124 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
108. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1108_chunk_feed_obs_fid_time_idx (cost=0.00..5.70 rows=124 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
109. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1120_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
110. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1120_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
111. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3823_chunk (cost=5.44..17.21 rows=101 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
112. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3823_chunk_feed_obs_fid_time_idx (cost=0.00..5.41 rows=101 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
113. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1071_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
114. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1071_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
115. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_149_chunk_feed_obs_fid_time_idx on _hyper_1_149_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
116. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_93_chunk_feed_obs_fid_time_idx on _hyper_1_93_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
117. 0.043 0.121 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_307_chunk (cost=40.50..1,802.61 rows=1,559 width=55) (actual time=0.121..0.121 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
  • Heap Blocks: exact=16
118. 0.078 0.078 ↓ 1.2 1,806 1

Bitmap Index Scan on _hyper_1_307_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..40.11 rows=1,559 width=0) (actual time=0.078..0.078 rows=1,806 loops=1)

  • Index Cond: (fid = 1000455)
119. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3924_chunk (cost=4.47..15.19 rows=41 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
120. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3924_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.46 rows=41 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
121. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_706_chunk (cost=0.00..1.19 rows=1 width=57) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 11
122. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on _hyper_1_1009_chunk (cost=0.00..2.00 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
123. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_541_chunk (cost=0.00..1.28 rows=1 width=56) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
124. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1100_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
125. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1100_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
126. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_714_chunk (cost=0.00..1.14 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 8
127. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1065_chunk (cost=5.48..17.30 rows=104 width=55) (actual time=0.002..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
128. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1065_chunk_feed_obs_fid_time_idx (cost=0.00..5.45 rows=104 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
129. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_523_chunk (cost=0.00..1.40 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 23
130. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_252_chunk_feed_obs_fid_time_idx on _hyper_1_252_chunk (cost=0.29..6.17 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
131. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3810_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
132. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3810_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
133. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3835_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
134. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3835_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
135. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_537_chunk (cost=0.00..1.28 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
136. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_839_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
137. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_839_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
138. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_526_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
139. 0.011 0.011 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
140. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_559_chunk (cost=0.00..1.39 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
141. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_131_chunk_feed_obs_fid_time_idx on _hyper_1_131_chunk (cost=0.28..6.05 rows=1 width=56) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
142. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3858_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
143. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3858_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
144. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_974_chunk (cost=4.13..8.15 rows=1 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
145. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_974_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.13 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
146. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_178_chunk_feed_obs_fid_time_idx on _hyper_1_178_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
147. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on _hyper_1_357_chunk (cost=0.00..1.28 rows=1 width=56) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
148. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_241_chunk_feed_obs_fid_time_idx on _hyper_1_241_chunk (cost=0.29..7.45 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
149. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_812_chunk (cost=5.48..17.30 rows=104 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
150. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_812_chunk_feed_obs_fid_time_idx (cost=0.00..5.45 rows=104 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
151. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_958_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
152. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_958_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
153. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_325_chunk (cost=0.00..1.39 rows=1 width=58) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
154. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_17_chunk_feed_obs_fid_time_idx on _hyper_1_17_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
155. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3801_chunk (cost=5.44..17.21 rows=101 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
156. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3801_chunk_feed_obs_fid_time_idx (cost=0.00..5.41 rows=101 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
157. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3859_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
158. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3859_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
159. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_1021_chunk_feed_obs_fid_time_idx on _hyper_1_1021_chunk (cost=0.12..8.15 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
160. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_142_chunk_feed_obs_fid_time_idx on _hyper_1_142_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
161. 0.002 0.002 ↓ 0.0 0 1

Index Scan using _hyper_1_3720_chunk_feed_obs_fid_time_idx on _hyper_1_3720_chunk (cost=0.15..6.70 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
162. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_980_chunk (cost=4.13..8.15 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
163. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_980_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.13 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
164. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_861_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
165. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_861_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
166. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_504_chunk (cost=0.00..1.35 rows=1 width=58) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 20
167. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_33_chunk_feed_obs_fid_time_idx on _hyper_1_33_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
168. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1003_chunk (cost=5.57..17.51 rows=111 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
169. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1003_chunk_feed_obs_fid_time_idx (cost=0.00..5.54 rows=111 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
170. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_633_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
171. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_816_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
172. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_816_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
173. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_900_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
174. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_900_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
175. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1079_chunk (cost=5.48..17.30 rows=104 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
176. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1079_chunk_feed_obs_fid_time_idx (cost=0.00..5.45 rows=104 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
177. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_109_chunk (cost=5.51..17.39 rows=107 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
178. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_109_chunk_feed_obs_fid_time_idx (cost=0.00..5.49 rows=107 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
179. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_914_chunk (cost=5.40..17.11 rows=98 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
180. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_914_chunk_feed_obs_fid_time_idx (cost=0.00..5.38 rows=98 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
181. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
182. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3925_chunk (cost=4.46..15.16 rows=40 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
183. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3925_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.45 rows=40 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
184. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1129_chunk (cost=5.41..17.14 rows=99 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
185. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1129_chunk_feed_obs_fid_time_idx (cost=0.00..5.39 rows=99 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
186. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on _hyper_1_644_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
187. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3849_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
188. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3849_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
189. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on _hyper_1_763_chunk (cost=0.00..1.21 rows=1 width=57) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 12
190. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_296_chunk_feed_obs_fid_time_idx on _hyper_1_296_chunk (cost=0.28..8.30 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
191. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on _hyper_1_686_chunk (cost=0.00..8.23 rows=1 width=57) (actual time=0.016..0.017 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 13
192. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_282_chunk_feed_obs_fid_time_idx on _hyper_1_282_chunk (cost=0.28..6.05 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
193. 0.011 0.011 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
194. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1117_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
195. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1117_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
196. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_10_chunk (cost=0.00..3.00 rows=1 width=55) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
197. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3948_chunk (cost=5.44..17.21 rows=101 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
198. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3948_chunk_feed_obs_fid_time_idx (cost=0.00..5.41 rows=101 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
199. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_146_chunk_feed_obs_fid_time_idx on _hyper_1_146_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
200. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_752_chunk (cost=0.00..1.21 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 12
201. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_98_chunk_feed_obs_fid_time_idx on _hyper_1_98_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
202. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_193_chunk_feed_obs_fid_time_idx on _hyper_1_193_chunk (cost=0.29..7.69 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
203. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_655_chunk_feed_obs_fid_time_idx on _hyper_1_655_chunk (cost=0.42..74.72 rows=28 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
204. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3882_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
205. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3882_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
206. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_853_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
207. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_853_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
208. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_243_chunk_feed_obs_fid_time_idx on _hyper_1_243_chunk (cost=0.29..6.17 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
209. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_617_chunk (cost=0.00..1.40 rows=1 width=57) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 23
210. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_674_chunk (cost=0.00..1.23 rows=1 width=57) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 13
211. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on _hyper_1_995_chunk (cost=0.00..8.00 rows=1 width=55) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
212. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_167_chunk_feed_obs_fid_time_idx on _hyper_1_167_chunk (cost=0.42..8.44 rows=1 width=58) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
213. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on _hyper_1_672_chunk (cost=0.00..8.23 rows=1 width=57) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 13
214. 0.001 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3966_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
215. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3966_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
216. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_478_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
217. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_3703_chunk_feed_obs_fid_time_idx on _hyper_1_3703_chunk (cost=0.15..7.63 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
218. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_956_chunk (cost=5.48..17.30 rows=104 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
219. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_956_chunk_feed_obs_fid_time_idx (cost=0.00..5.45 rows=104 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
220. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_145_chunk_feed_obs_fid_time_idx on _hyper_1_145_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
221. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3892_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
222. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3892_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
223. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
224. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_198_chunk_feed_obs_fid_time_idx on _hyper_1_198_chunk (cost=0.28..6.05 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
225. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3973_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
226. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3973_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
227. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_629_chunk (cost=0.00..1.28 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
228. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_104_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
229. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_104_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
230. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
231. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1081_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
232. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1081_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
233. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_163_chunk_feed_obs_fid_time_idx on _hyper_1_163_chunk (cost=0.42..8.44 rows=1 width=58) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
234. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1134_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
235. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1134_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
236. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_533_chunk (cost=0.00..1.28 rows=1 width=56) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
237. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_71_chunk_feed_obs_fid_time_idx on _hyper_1_71_chunk (cost=0.15..7.61 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
238. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_588_chunk (cost=0.00..1.42 rows=1 width=57) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
239. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1026_chunk (cost=5.69..17.81 rows=121 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
240. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1026_chunk_feed_obs_fid_time_idx (cost=0.00..5.66 rows=121 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
241. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_343_chunk (cost=0.00..1.28 rows=1 width=57) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
242. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1153_chunk (cost=5.35..16.99 rows=94 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
243. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1153_chunk_feed_obs_fid_time_idx (cost=0.00..5.33 rows=94 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
244. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on _hyper_1_624_chunk (cost=0.00..1.40 rows=1 width=57) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 23
245. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_186_chunk_feed_obs_fid_time_idx on _hyper_1_186_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
246. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_626_chunk (cost=0.00..1.40 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 23
247. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_823_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
248. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_823_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
249. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_705_chunk (cost=0.00..1.49 rows=1 width=57) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 28
250. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_480_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
251. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_337_chunk (cost=0.00..1.28 rows=1 width=58) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
252. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3834_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
253. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3834_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
254. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on _hyper_1_727_chunk (cost=0.00..1.14 rows=1 width=57) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 8
255. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_280_chunk_feed_obs_fid_time_idx on _hyper_1_280_chunk (cost=0.28..6.05 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
256. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_886_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
257. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_886_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
258. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3804_chunk (cost=5.43..17.18 rows=100 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
259. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3804_chunk_feed_obs_fid_time_idx (cost=0.00..5.40 rows=100 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
260. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_297_chunk_feed_obs_fid_time_idx on _hyper_1_297_chunk (cost=0.29..8.30 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
261. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
262. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1164_chunk (cost=6.08..18.72 rows=151 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
263. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1164_chunk_feed_obs_fid_time_idx (cost=0.00..6.04 rows=151 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
264. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_314_chunk_feed_obs_fid_time_idx on _hyper_1_314_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
265. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_400_chunk (cost=0.00..1.31 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 18
266. 0.004 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_893_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
267. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_893_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
268. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on _hyper_1_689_chunk (cost=0.00..8.21 rows=1 width=57) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 12
269. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1139_chunk (cost=5.43..17.18 rows=100 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
270. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1139_chunk_feed_obs_fid_time_idx (cost=0.00..5.40 rows=100 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
271. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on _hyper_1_473_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
272. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_636_chunk (cost=0.00..1.42 rows=1 width=57) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
273. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1000_chunk (cost=5.43..17.18 rows=100 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
274. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1000_chunk_feed_obs_fid_time_idx (cost=0.00..5.40 rows=100 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
275. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_819_chunk (cost=5.37..17.05 rows=96 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
276. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_819_chunk_feed_obs_fid_time_idx (cost=0.00..5.35 rows=96 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
277. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_595_chunk (cost=0.00..1.39 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
278. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_47_chunk_feed_obs_fid_time_idx on _hyper_1_47_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
279. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_813_chunk (cost=5.48..17.30 rows=104 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
280. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_813_chunk_feed_obs_fid_time_idx (cost=0.00..5.45 rows=104 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
281. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3775_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
282. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3775_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
283. 0.020 0.020 ↓ 0.0 0 1

Index Scan using _hyper_1_211_chunk_feed_obs_fid_time_idx on _hyper_1_211_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
284. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_970_chunk (cost=4.13..8.15 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
285. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_970_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.13 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
286. 0.020 0.020 ↓ 0.0 0 1

Index Scan using _hyper_1_15_chunk_feed_obs_fid_time_idx on _hyper_1_15_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
287. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_304_chunk_feed_obs_fid_time_idx on _hyper_1_304_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
288. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_77_chunk_feed_obs_fid_time_idx on _hyper_1_77_chunk (cost=0.15..7.61 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
289. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_125_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
290. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_125_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
291. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_140_chunk_feed_obs_fid_time_idx on _hyper_1_140_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
292. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3926_chunk (cost=4.47..15.19 rows=41 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
293. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3926_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.46 rows=41 width=0) (actual time=0.001..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
294. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_1_153_chunk_feed_obs_fid_time_idx on _hyper_1_153_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
295. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_806_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
296. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_806_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
297. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_56_chunk_feed_obs_fid_time_idx on _hyper_1_56_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
298. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_3724_chunk_feed_obs_fid_time_idx on _hyper_1_3724_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
299. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on _hyper_1_590_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
300. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_579_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
301. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_946_chunk (cost=5.48..17.30 rows=104 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
302. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_946_chunk_feed_obs_fid_time_idx (cost=0.00..5.45 rows=104 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
303. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on _hyper_1_729_chunk (cost=0.00..1.14 rows=1 width=57) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 8
304. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_123_chunk (cost=5.95..18.42 rows=141 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
305. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_123_chunk_feed_obs_fid_time_idx (cost=0.00..5.91 rows=141 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
306. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3875_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
307. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3875_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
308. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_885_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
309. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_885_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
310. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1045_chunk (cost=6.11..18.81 rows=154 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
311. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1045_chunk_feed_obs_fid_time_idx (cost=0.00..6.08 rows=154 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
312. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_891_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
313. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_891_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
314. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_880_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
315. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_880_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
316. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on _hyper_1_468_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
317. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_333_chunk (cost=0.00..1.28 rows=1 width=56) (actual time=0.010..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
318. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_575_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
319. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_3733_chunk_feed_obs_fid_time_idx on _hyper_1_3733_chunk (cost=0.15..5.95 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
320. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3796_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
321. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3796_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
322. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3979_chunk (cost=5.44..17.21 rows=101 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
323. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3979_chunk_feed_obs_fid_time_idx (cost=0.00..5.41 rows=101 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
324. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3853_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
325. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3853_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
326. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_915_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
327. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_915_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
328. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_189_chunk_feed_obs_fid_time_idx on _hyper_1_189_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
329. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on _hyper_1_712_chunk (cost=0.00..2.14 rows=1 width=57) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 8
330. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_404_chunk (cost=0.00..1.31 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 18
331. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1141_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
332. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1141_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
333. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_547_chunk (cost=0.00..1.28 rows=1 width=57) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
334. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_923_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
335. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_923_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
336. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_952_chunk (cost=5.40..17.11 rows=98 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
337. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_952_chunk_feed_obs_fid_time_idx (cost=0.00..5.38 rows=98 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
338. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on _hyper_1_997_chunk (cost=0.00..8.00 rows=1 width=55) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
339. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_578_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
340. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_977_chunk (cost=4.13..8.15 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
341. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_977_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.13 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
342. 0.000 0.020 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1118_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.020..0.020 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
343. 0.020 0.020 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1118_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
344. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_556_chunk (cost=0.00..1.30 rows=1 width=57) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 17
345. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1123_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
346. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1123_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
347. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_376_chunk (cost=0.00..1.28 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
348. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_3825_chunk (cost=0.00..2.00 rows=1 width=55) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
349. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3838_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
350. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3838_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
351. 0.000 0.017 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_879_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.017..0.017 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
352. 0.017 0.017 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_879_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
353. 0.037 0.037 ↓ 0.0 0 1

Seq Scan on _hyper_1_723_chunk (cost=0.00..4.89 rows=1 width=57) (actual time=0.037..0.037 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 165
354. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_566_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
355. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_515_chunk (cost=0.00..1.39 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
356. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on _hyper_1_695_chunk (cost=0.00..1.19 rows=1 width=57) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 11
357. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_737_chunk (cost=0.00..1.14 rows=1 width=57) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 8
358. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3842_chunk (cost=5.48..17.30 rows=104 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
359. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3842_chunk_feed_obs_fid_time_idx (cost=0.00..5.45 rows=104 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
360. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_303_chunk_feed_obs_fid_time_idx on _hyper_1_303_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
361. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3846_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
362. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3846_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
363. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
364. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1131_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
365. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1131_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
366. 0.006 0.006 ↓ 0.0 0 1

Index Scan using _hyper_1_165_chunk_feed_obs_fid_time_idx on _hyper_1_165_chunk (cost=0.42..8.44 rows=1 width=58) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
367. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_287_chunk_feed_obs_fid_time_idx on _hyper_1_287_chunk (cost=0.28..6.05 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
368. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on _hyper_1_748_chunk (cost=0.00..1.14 rows=1 width=57) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 8
369. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_3997_chunk_feed_obs_fid_time_idx on _hyper_1_3997_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
370. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_21_chunk_feed_obs_fid_time_idx on _hyper_1_21_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
371. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3955_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.002..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
372. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3955_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
373. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3959_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
374. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3959_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
375. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_1056_chunk_feed_obs_fid_time_idx on _hyper_1_1056_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
376. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_3707_chunk_feed_obs_fid_time_idx on _hyper_1_3707_chunk (cost=0.15..7.39 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
377. 0.012 0.012 ↓ 0.0 0 1

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

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
378. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_570_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
379. 0.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1156_chunk (cost=5.59..17.57 rows=113 width=55) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
380. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1156_chunk_feed_obs_fid_time_idx (cost=0.00..5.56 rows=113 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
381. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3942_chunk (cost=4.44..15.08 rows=37 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
382. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3942_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.43 rows=37 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
383. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on _hyper_1_281_chunk (cost=0.00..8.07 rows=1 width=55) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 4
384. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_301_chunk_feed_obs_fid_time_idx on _hyper_1_301_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
385. 0.000 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1049_chunk (cost=6.13..18.84 rows=155 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
386. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1049_chunk_feed_obs_fid_time_idx (cost=0.00..6.09 rows=155 width=0) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
387. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_1_181_chunk_feed_obs_fid_time_idx on _hyper_1_181_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
388. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on _hyper_1_367_chunk (cost=0.00..1.28 rows=1 width=57) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
389. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1137_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
390. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1137_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
391. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3912_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
392. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3912_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
393. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_822_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
394. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_822_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
395. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_983_chunk (cost=4.13..8.15 rows=1 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
396. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_983_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.13 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
397. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_896_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
398. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_896_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
399. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on _hyper_1_609_chunk (cost=0.00..1.39 rows=1 width=58) (actual time=0.014..0.014 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
400. 0.034 0.110 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_298_chunk (cost=40.38..845.68 rows=1,560 width=55) (actual time=0.110..0.110 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
  • Heap Blocks: exact=15
401. 0.076 0.076 ↓ 1.2 1,846 1

Bitmap Index Scan on _hyper_1_298_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..39.99 rows=1,560 width=0) (actual time=0.076..0.076 rows=1,846 loops=1)

  • Index Cond: (fid = 1000455)
402. 0.016 0.016 ↓ 0.0 0 1

Seq Scan on _hyper_1_429_chunk (cost=0.00..1.39 rows=1 width=58) (actual time=0.016..0.016 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
403. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on _hyper_1_718_chunk (cost=0.00..1.21 rows=1 width=57) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 12
404. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_3730_chunk_feed_obs_fid_time_idx on _hyper_1_3730_chunk (cost=0.15..5.97 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
405. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_690_chunk (cost=0.00..4.23 rows=1 width=57) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 13
406. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_673_chunk (cost=0.00..1.23 rows=1 width=57) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 13
407. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3793_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
408. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3793_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
409. 0.003 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_931_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
410. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_931_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
411. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_625_chunk (cost=0.00..1.40 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 23
412. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_112_chunk (cost=5.26..16.78 rows=87 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
413. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_112_chunk_feed_obs_fid_time_idx (cost=0.00..5.24 rows=87 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
414. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_1_254_chunk_feed_obs_fid_time_idx on _hyper_1_254_chunk (cost=0.29..7.00 rows=1 width=55) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
415. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_656_chunk_feed_obs_fid_time_idx on _hyper_1_656_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
416. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3901_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
417. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3901_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
418. 0.005 0.005 ↓ 0.0 0 1

Index Scan using _hyper_1_96_chunk_feed_obs_fid_time_idx on _hyper_1_96_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
419. 0.003 0.003 ↓ 0.0 0 1

Index Scan using _hyper_1_3729_chunk_feed_obs_fid_time_idx on _hyper_1_3729_chunk (cost=0.15..5.94 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
420. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3931_chunk (cost=4.47..15.19 rows=41 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (fid = 1000455)
  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
421. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3931_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..4.46 rows=41 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
422. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_694_chunk (cost=0.00..1.23 rows=1 width=57) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 13
423. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_581_chunk (cost=0.00..1.39 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 22
424. 0.004 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_863_chunk (cost=4.14..8.16 rows=1 width=55) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
425. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_863_chunk_feed_obs_fid_time_idx (cost=0.00..4.14 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
426. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_3784_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
427. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_3784_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
428. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_818_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
429. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_818_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
430. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_396_chunk (cost=0.00..1.28 rows=1 width=56) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 16
431. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1136_chunk (cost=5.46..17.27 rows=103 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
432. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1136_chunk_feed_obs_fid_time_idx (cost=0.00..5.44 rows=103 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
433. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_820_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
434. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_820_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
435. 0.002 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_954_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
436. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_954_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
437. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_679_chunk (cost=0.00..1.23 rows=1 width=57) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 13
438. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_107_chunk (cost=5.45..17.24 rows=102 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
439. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_107_chunk_feed_obs_fid_time_idx (cost=0.00..5.43 rows=102 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
440. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_935_chunk (cost=4.67..15.39 rows=41 width=55) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
441. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_935_chunk_feed_obs_fid_time_idx (cost=0.00..4.66 rows=41 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
442. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on _hyper_1_493_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
443. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1029_chunk (cost=5.57..17.51 rows=111 width=55) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
444. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1029_chunk_feed_obs_fid_time_idx (cost=0.00..5.54 rows=111 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
445. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_1148_chunk (cost=5.44..17.21 rows=101 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
446. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_1148_chunk_feed_obs_fid_time_idx (cost=0.00..5.41 rows=101 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
447. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_1_600_chunk (cost=0.00..1.42 rows=1 width=58) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone) AND (fid = 1000455))
  • Rows Removed by Filter: 24
448. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on _hyper_1_937_chunk (cost=4.67..15.39 rows=41 width=55) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))
449. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on _hyper_1_937_chunk_feed_obs_fid_time_idx (cost=0.00..4.66 rows=41 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((fid = 1000455) AND ("time" >= '1992-01-01 08:00:00'::timestamp without time zone) AND ("time" <= '2019-05-08 23:46:12'::timestamp without time zone))