explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 65ef

Settings
# exclusive inclusive rows x rows loops node
1. 50.932 378.611 ↓ 22.1 239,752 1

Custom Scan (GapFill) (cost=39,466.56..39,493.70 rows=10,856 width=91) (actual time=327.648..378.611 rows=239,752 loops=1)

2. 1.228 327.679 ↑ 16.3 664 1

Sort (cost=39,466.56..39,493.70 rows=10,856 width=91) (actual time=327.641..327.679 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. 0.000 326.451 ↑ 16.3 664 1

Finalize HashAggregate (cost=38,576.03..38,738.87 rows=10,856 width=91) (actual time=326.136..326.451 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. 321.509 328.531 ↑ 16.3 664 1

Gather (cost=37,056.19..38,277.49 rows=10,856 width=115) (actual time=149.013..328.531 rows=664 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
5. 1.009 7.022 ↑ 32.7 332 2

Partial HashAggregate (cost=36,056.19..36,191.89 rows=10,856 width=115) (actual time=6.859..7.022 rows=332 loops=2)

  • 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
6. 0.187 6.013 ↑ 61.3 1,048 2

Result (cost=0.00..33,485.03 rows=64,279 width=55) (actual time=2.936..6.013 rows=1,048 loops=2)

7. 4.975 5.826 ↑ 61.3 1,048 2

Append (cost=0.00..32,681.54 rows=64,279 width=55) (actual time=2.934..5.826 rows=1,048 loops=2)

8. 0.001 0.001 ↓ 0.0 0 2

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

  • 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))
9. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1074_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
10. 0.011 0.011 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_251_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_251_chunk (cost=0.41..6.29 rows=1 width=55) (actual time=0.011..0.011 rows=0 loops=2)

  • Index 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))
11. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_887_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
12. 0.002 0.002 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_264_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_264_chunk (cost=0.29..6.17 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=2)

  • Index 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))
13. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1070_chunk (cost=0.00..16.38 rows=60 width=55) (actual time=0.000..0.000 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_3871_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
15. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1080_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
16. 0.007 0.007 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_496_chunk (cost=0.00..1.23 rows=1 width=58) (actual time=0.007..0.007 rows=0 loops=2)

  • 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
17. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_455_chunk (cost=0.00..1.25 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
18. 0.000 0.134 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_1087_chunk (cost=17.56..38.26 rows=97 width=55) (actual time=0.134..0.134 rows=0 loops=2)

  • 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=2
19. 0.212 0.212 ↑ 1.0 165 1

Bitmap Index Scan on _hyper_1_1087_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..17.52 rows=165 width=0) (actual time=0.212..0.212 rows=165 loops=1)

  • Index Cond: (fid = 1000455)
20. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_630_chunk (cost=0.00..1.25 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
21. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1101_chunk (cost=0.00..16.38 rows=60 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
22. 0.004 0.004 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_209_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_209_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.004..0.004 rows=0 loops=2)

  • Index 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))
23. 0.002 0.002 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_276_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_276_chunk (cost=0.28..8.29 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=2)

  • Index 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))
24. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_606_chunk (cost=0.00..1.24 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
25. 0.000 0.016 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_850_chunk (cost=17.55..38.24 rows=96 width=55) (actual time=0.016..0.016 rows=0 loops=2)

  • 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=2
26. 0.022 0.022 ↑ 1.0 164 1

Bitmap Index Scan on _hyper_1_850_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..17.51 rows=164 width=0) (actual time=0.022..0.022 rows=164 loops=1)

  • Index Cond: (fid = 1000455)
27. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_599_chunk (cost=0.00..1.25 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_3903_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
29. 0.001 0.001 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1083_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.001 rows=0 loops=2)

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

Parallel Bitmap Heap Scan on _hyper_1_856_chunk (cost=17.57..38.29 rows=98 width=55) (actual time=0.017..0.017 rows=0 loops=2)

  • 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=2
31. 0.026 0.026 ↑ 1.0 167 1

Bitmap Index Scan on _hyper_1_856_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..17.53 rows=167 width=0) (actual time=0.026..0.026 rows=167 loops=1)

  • Index Cond: (fid = 1000455)
32. 0.001 0.001 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3805_chunk (cost=0.00..16.38 rows=59 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • 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))
33. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3795_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
34. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_756_chunk (cost=0.00..1.11 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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: 6
35. 0.000 0.060 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_1124_chunk (cost=71.84..277.19 rows=877 width=55) (actual time=0.060..0.060 rows=0 loops=2)

  • 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=12
36. 0.085 0.085 ↑ 1.0 1,491 1

Bitmap Index Scan on _hyper_1_1124_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..71.47 rows=1,491 width=0) (actual time=0.085..0.085 rows=1,491 loops=1)

  • Index Cond: (fid = 1000455)
37. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_3995_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_3995_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_872_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
39. 0.005 0.005 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_151_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_151_chunk (cost=0.42..8.44 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_921_chunk (cost=0.00..16.38 rows=58 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
41. 0.002 0.002 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_253_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_253_chunk (cost=0.41..8.43 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_119_chunk (cost=0.00..16.38 rows=65 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
43. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_270_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_3851_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
45. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_437_chunk (cost=0.00..1.23 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_3828_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
47. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_101_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_101_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
48. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_339_chunk (cost=0.00..1.16 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
49. 0.002 0.004 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_3937_chunk (cost=4.47..14.89 rows=24 width=55) (actual time=0.004..0.004 rows=0 loops=2)

  • 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))
50. 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)
51. 0.000 0.013 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_847_chunk (cost=17.57..38.28 rows=98 width=55) (actual time=0.013..0.013 rows=0 loops=2)

  • 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=2
52. 0.020 0.020 ↑ 1.0 166 1

Bitmap Index Scan on _hyper_1_847_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..17.53 rows=166 width=0) (actual time=0.020..0.020 rows=166 loops=1)

  • Index Cond: (fid = 1000455)
53. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_82_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_82_chunk (cost=0.15..7.60 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_3949_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
55. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1043_chunk (cost=0.00..16.38 rows=89 width=55) (actual time=0.000..0.000 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_1048_chunk (cost=0.00..16.38 rows=91 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
57. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_25_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_25_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
58. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_3704_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_3704_chunk (cost=0.15..7.50 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
59. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_359_chunk (cost=0.00..1.16 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
60. 0.000 0.055 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_1060_chunk (cost=73.25..164.47 rows=984 width=55) (actual time=0.055..0.055 rows=0 loops=2)

  • 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=13
61. 0.072 0.072 ↑ 1.0 1,673 1

Bitmap Index Scan on _hyper_1_1060_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..72.83 rows=1,673 width=0) (actual time=0.072..0.072 rows=1,673 loops=1)

  • Index Cond: (fid = 1000455)
62. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_26_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_26_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
63. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_213_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_213_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_3808_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
65. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_3989_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_3989_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
66. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_3715_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_3715_chunk (cost=0.15..6.86 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
67. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3895_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
68. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_136_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_136_chunk (cost=0.29..6.05 rows=1 width=56) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
69. 0.002 0.002 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_196_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_196_chunk (cost=0.27..7.44 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=2)

  • Index 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))
70. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_218_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_218_chunk (cost=0.29..8.30 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
71. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_373_chunk (cost=0.00..1.16 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
72. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3911_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
73. 0.000 0.002 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_969_chunk (cost=4.13..8.14 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=2)

  • 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))
74. 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)
75. 0.002 0.002 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_230_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_230_chunk (cost=0.29..6.17 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=2)

  • Index 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))
76. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_414_chunk (cost=0.00..1.23 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
77. 0.000 0.051 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_1116_chunk (cost=71.97..277.50 rows=887 width=55) (actual time=0.051..0.051 rows=0 loops=2)

  • 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=12
78. 0.067 0.067 ↑ 1.0 1,508 1

Bitmap Index Scan on _hyper_1_1116_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..71.59 rows=1,508 width=0) (actual time=0.067..0.067 rows=1,508 loops=1)

  • Index Cond: (fid = 1000455)
79. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3781_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
80. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_449_chunk (cost=0.00..1.24 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
81. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1146_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
82. 0.005 0.005 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_667_chunk (cost=0.00..8.13 rows=1 width=57) (actual time=0.005..0.005 rows=0 loops=2)

  • 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: 6
83. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_899_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
84. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1108_chunk (cost=0.00..16.38 rows=73 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
85. 0.000 0.049 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_1120_chunk (cost=68.16..274.93 rows=901 width=55) (actual time=0.049..0.049 rows=0 loops=2)

  • 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=12
86. 0.068 0.068 ↑ 1.0 1,532 1

Bitmap Index Scan on _hyper_1_1120_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..67.77 rows=1,532 width=0) (actual time=0.068..0.068 rows=1,532 loops=1)

  • Index Cond: (fid = 1000455)
87. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3823_chunk (cost=0.00..16.38 rows=59 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
88. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1071_chunk (cost=0.00..16.38 rows=60 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
89. 0.005 0.005 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_149_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_149_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=2)

  • Index 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))
90. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_93_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_93_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
91. 0.000 0.064 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_307_chunk (cost=41.30..1,811.71 rows=978 width=55) (actual time=0.064..0.064 rows=0 loops=2)

  • 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
92. 0.082 0.082 ↓ 1.1 1,806 1

Bitmap Index Scan on _hyper_1_307_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..40.89 rows=1,662 width=0) (actual time=0.082..0.082 rows=1,806 loops=1)

  • Index Cond: (fid = 1000455)
93. 0.001 0.004 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_3924_chunk (cost=4.47..14.89 rows=24 width=55) (actual time=0.004..0.004 rows=0 loops=2)

  • 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.003 0.003 ↓ 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.002..0.003 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
95. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_706_chunk (cost=0.00..1.11 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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: 6
96. 0.001 0.001 ↓ 0.0 0 2

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

  • 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))
97. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_541_chunk (cost=0.00..1.16 rows=1 width=56) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
98. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1100_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
99. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_714_chunk (cost=0.00..1.08 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
100. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1065_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
101. 0.008 0.008 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_523_chunk (cost=0.00..1.24 rows=1 width=57) (actual time=0.008..0.008 rows=0 loops=2)

  • 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
102. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_252_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_252_chunk (cost=0.41..6.29 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
103. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3810_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
104. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3835_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
105. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_537_chunk (cost=0.00..1.16 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
106. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_839_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
107. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_526_chunk (cost=0.00..1.25 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
108. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_489_chunk (cost=0.00..1.25 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
109. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_559_chunk (cost=0.00..1.23 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
110. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_131_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_131_chunk (cost=0.28..6.05 rows=1 width=56) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
111. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3858_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
112. 0.001 0.003 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_974_chunk (cost=4.13..8.14 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • 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))
113. 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)
114. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_178_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_178_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
115. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_357_chunk (cost=0.00..1.16 rows=1 width=56) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
116. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_241_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_241_chunk (cost=0.41..7.56 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
117. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_812_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
118. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_958_chunk (cost=0.00..16.38 rows=60 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
119. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_325_chunk (cost=0.00..1.23 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
120. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_17_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_17_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
121. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3801_chunk (cost=0.00..16.38 rows=59 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
122. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3859_chunk (cost=0.00..16.38 rows=60 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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.002 0.002 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_1021_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_1021_chunk (cost=0.28..8.30 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • Index 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))
124. 0.004 0.004 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_142_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_142_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=2)

  • Index 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))
125. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_3720_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_3720_chunk (cost=0.15..6.70 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
126. 0.001 0.003 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_980_chunk (cost=4.13..8.14 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • 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))
127. 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)
128. 0.000 0.016 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_861_chunk (cost=17.52..38.17 rows=94 width=55) (actual time=0.015..0.016 rows=0 loops=2)

  • 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=2
129. 0.021 0.021 ↑ 1.0 160 1

Bitmap Index Scan on _hyper_1_861_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..17.48 rows=160 width=0) (actual time=0.021..0.021 rows=160 loops=1)

  • Index Cond: (fid = 1000455)
130. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_504_chunk (cost=0.00..1.21 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=2)

  • 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: 10
131. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_33_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_33_chunk (cost=0.15..6.81 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
132. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1003_chunk (cost=0.00..16.38 rows=65 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
133. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_633_chunk (cost=0.00..1.25 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
134. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_816_chunk (cost=0.00..16.38 rows=60 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
135. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_900_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
136. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1079_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
137. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_109_chunk (cost=0.00..16.38 rows=63 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
138. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_914_chunk (cost=0.00..16.38 rows=58 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
139. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_524_chunk (cost=0.00..1.23 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
140. 0.000 0.003 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_3925_chunk (cost=4.46..14.87 rows=24 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • 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))
141. 0.004 0.004 ↓ 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.004..0.004 rows=0 loops=1)

  • Index Cond: (fid = 1000455)
142. 0.000 0.050 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_1129_chunk (cost=71.68..275.81 rows=865 width=55) (actual time=0.050..0.050 rows=0 loops=2)

  • 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=12
143. 0.066 0.066 ↑ 1.0 1,470 1

Bitmap Index Scan on _hyper_1_1129_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..71.31 rows=1,470 width=0) (actual time=0.066..0.066 rows=1,470 loops=1)

  • Index Cond: (fid = 1000455)
144. 0.004 0.004 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_644_chunk (cost=0.00..1.25 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=2)

  • 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
145. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3849_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
146. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_763_chunk (cost=0.00..1.12 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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: 6
147. 0.002 0.002 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_296_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_296_chunk (cost=0.28..8.30 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=2)

  • Index 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))
148. 0.005 0.005 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_686_chunk (cost=0.00..8.13 rows=1 width=57) (actual time=0.005..0.005 rows=0 loops=2)

  • 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: 6
149. 0.002 0.002 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_282_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_282_chunk (cost=0.28..6.05 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=2)

  • Index 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))
150. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_428_chunk (cost=0.00..1.23 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
151. 0.000 0.046 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_1117_chunk (cost=66.98..267.19 rows=812 width=55) (actual time=0.046..0.046 rows=0 loops=2)

  • 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=11
152. 0.062 0.062 ↑ 1.0 1,380 1

Bitmap Index Scan on _hyper_1_1117_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..66.63 rows=1,380 width=0) (actual time=0.062..0.062 rows=1,380 loops=1)

  • Index Cond: (fid = 1000455)
153. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_10_chunk (cost=0.00..3.49 rows=1 width=55) (actual time=0.002..0.003 rows=0 loops=2)

  • 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))
154. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3948_chunk (cost=0.00..16.38 rows=59 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
155. 0.005 0.005 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_146_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_146_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=2)

  • Index 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))
156. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_752_chunk (cost=0.00..1.12 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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: 6
157. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_98_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_98_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
158. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_193_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_193_chunk (cost=0.29..7.68 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
159. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_655_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_655_chunk (cost=0.42..91.58 rows=21 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
160. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3882_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
161. 0.000 0.015 ↓ 0.0 0 2

Parallel Bitmap Heap Scan on _hyper_1_853_chunk (cost=17.58..38.31 rows=99 width=55) (actual time=0.015..0.015 rows=0 loops=2)

  • 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=2
162. 0.020 0.020 ↑ 1.0 168 1

Bitmap Index Scan on _hyper_1_853_chunk_feed_obs_fid_qc_agg_idx (cost=0.00..17.54 rows=168 width=0) (actual time=0.020..0.020 rows=168 loops=1)

  • Index Cond: (fid = 1000455)
163. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_243_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_243_chunk (cost=0.41..6.29 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
164. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_617_chunk (cost=0.00..1.24 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
165. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_674_chunk (cost=0.00..1.13 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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: 6
166. 0.004 0.004 ↓ 0.0 0 2

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

  • 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))
167. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_167_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_167_chunk (cost=0.42..8.44 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
168. 0.005 0.005 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_672_chunk (cost=0.00..8.13 rows=1 width=57) (actual time=0.005..0.005 rows=0 loops=2)

  • 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: 6
169. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3966_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
170. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_478_chunk (cost=0.00..1.25 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
171. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_3703_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_3703_chunk (cost=0.15..7.62 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
172. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_956_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
173. 0.004 0.004 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_145_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_145_chunk (cost=0.42..6.19 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=2)

  • Index 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))
174. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3892_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
175. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_458_chunk (cost=0.00..1.23 rows=1 width=58) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
176. 0.002 0.002 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_198_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_198_chunk (cost=0.28..6.04 rows=1 width=55) (actual time=0.002..0.002 rows=0 loops=2)

  • Index 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))
177. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_3973_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
178. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_629_chunk (cost=0.00..1.16 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
179. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_104_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
180. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_413_chunk (cost=0.00..1.23 rows=1 width=58) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
181. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1081_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
182. 0.004 0.004 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_163_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_163_chunk (cost=0.42..8.44 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=2)

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

Parallel Seq Scan on _hyper_1_1134_chunk (cost=0.00..16.38 rows=61 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
184. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_533_chunk (cost=0.00..1.16 rows=1 width=56) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
185. 0.001 0.001 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_71_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_71_chunk (cost=0.15..7.60 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=2)

  • Index 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))
186. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_588_chunk (cost=0.00..1.25 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
187. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1026_chunk (cost=0.00..16.38 rows=71 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
188. 0.002 0.002 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_343_chunk (cost=0.00..1.16 rows=1 width=57) (actual time=0.002..0.002 rows=0 loops=2)

  • 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
189. 0.000 0.000 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_1153_chunk (cost=0.00..16.38 rows=55 width=55) (actual time=0.000..0.000 rows=0 loops=2)

  • 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))
190. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_624_chunk (cost=0.00..1.24 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=2)

  • 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
191. 0.003 0.003 ↓ 0.0 0 2

Parallel Index Scan using _hyper_1_186_chunk_feed_obs_fid_qc_agg_idx on _hyper_1_186_chunk (cost=0.29..8.31 rows=1 width=55) (actual time=0.003..0.003 rows=0 loops=2)

  • Index 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))
192. 0.003 0.003 ↓ 0.0 0 2

Parallel Seq Scan on _hyper_1_626_chunk (cost=0.00..1.24 rows=1 width=57) (actual time=0.003..0.003 rows=0 loops=2)