explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pcFm

Settings
# exclusive inclusive rows x rows loops node
1. 0.846 0.944 ↓ 34.0 34 1

CTE Scan on observations (cost=204.05..205.65 rows=1 width=102) (actual time=0.931..0.944 rows=34 loops=1)

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

CTE observations

3. 0.128 0.853 ↑ 1.9 34 1

HashAggregate (cost=200.19..201.15 rows=64 width=92) (actual time=0.824..0.853 rows=34 loops=1)

  • Group Key: date_trunc('month'::text, feed_obs.""time""), feed_obs.fid, feed_obs.lat, feed_obs.lon, feed_obs.z
4. 0.033 0.725 ↑ 1.9 34 1

Result (cost=0.00..197.63 rows=64 width=56) (actual time=0.047..0.725 rows=34 loops=1)

5. 0.009 0.692 ↑ 1.9 34 1

Append (cost=0.00..196.83 rows=64 width=56) (actual time=0.041..0.692 rows=34 loops=1)

6. 0.006 0.006 ↓ 0.0 0 1

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

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

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

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

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

  • Index Cond: (fid = 1000258)
9. 0.027 0.027 ↑ 1.0 2 1

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

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

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

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

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

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

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

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

Index Scan using _hyper_1_1015_chunk_feed_obs_fid_time_idx on _hyper_1_1015_chunk (cost=0.15..6.02 rows=1 width=55) (actual time=0.010..0.010 rows=0 loops=1)

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

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

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

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

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

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

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

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

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

Index Scan using _hyper_1_1012_chunk_feed_obs_fid_time_idx on _hyper_1_1012_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.013..0.013 rows=0 loops=1)

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

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

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

Index Scan using _hyper_1_1027_chunk_feed_obs_fid_time_idx on _hyper_1_1027_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.021..0.021 rows=0 loops=1)

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

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

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

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

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

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

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

Index Scan using _hyper_1_1023_chunk_feed_obs_fid_time_idx on _hyper_1_1023_chunk (cost=0.15..6.04 rows=1 width=55) (actual time=0.014..0.015 rows=0 loops=1)

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

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

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

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

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

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

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

Seq Scan on _hyper_1_643_chunk (cost=0.00..3.58 rows=2 width=57) (actual time=0.015..0.027 rows=2 loops=1)

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

Seq Scan on _hyper_1_625_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.009..0.019 rows=2 loops=1)

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

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

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

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

  • Index Cond: (fid = 1000258)
32. 0.019 0.019 ↓ 0.0 0 1

Index Scan using _hyper_1_1028_chunk_feed_obs_fid_time_idx on _hyper_1_1028_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.019..0.019 rows=0 loops=1)

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

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

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

Seq Scan on _hyper_1_624_chunk (cost=0.00..1.40 rows=2 width=57) (actual time=0.008..0.018 rows=2 loops=1)

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

Index Scan using _hyper_1_1024_chunk_feed_obs_fid_time_idx on _hyper_1_1024_chunk (cost=0.15..5.92 rows=1 width=55) (actual time=0.018..0.018 rows=0 loops=1)

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

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

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

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

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

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

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

Seq Scan on _hyper_1_615_chunk (cost=0.00..1.40 rows=1 width=57) (actual time=0.015..0.016 rows=0 loops=1)

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

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

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

Index Scan using _hyper_1_1017_chunk_feed_obs_fid_time_idx on _hyper_1_1017_chunk (cost=0.15..6.11 rows=1 width=55) (actual time=0.013..0.013 rows=0 loops=1)

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

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

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

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

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

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

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

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

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

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

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

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

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

Index Scan using _hyper_1_1025_chunk_feed_obs_fid_time_idx on _hyper_1_1025_chunk (cost=0.15..8.17 rows=1 width=55) (actual time=0.019..0.019 rows=0 loops=1)

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

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

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

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

  • Index Cond: (fid = 1000258)
51.          

Initplan (forCTE Scan)

52. 0.009 0.076 ↑ 1.0 1 1

Aggregate (cost=1.44..1.45 rows=1 width=8) (actual time=0.075..0.076 rows=1 loops=1)

53. 0.067 0.067 ↑ 1.9 34 1

CTE Scan on observations observations_1 (cost=0.00..1.28 rows=64 width=8) (actual time=0.001..0.067 rows=34 loops=1)

  • Filter: (value_count IS NOT NULL)
54. 0.006 0.022 ↑ 1.0 1 1

Aggregate (cost=1.44..1.45 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=1)

55. 0.016 0.016 ↑ 1.9 34 1

CTE Scan on observations observations_2 (cost=0.00..1.28 rows=64 width=8) (actual time=0.001..0.016 rows=34 loops=1)

  • Filter: (value_count IS NOT NULL)
Planning time : 31.346 ms
Execution time : 1.906 ms