explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6haF

Settings
# exclusive inclusive rows x rows loops node
1. 1.310 414.244 ↓ 229.0 229 1

Hash Join (cost=97,687.72..97,700.81 rows=1 width=12) (actual time=408.613..414.244 rows=229 loops=1)

  • Hash Cond: (((time_bucket('01:00:00'::interval, e_8."time")) = (time_bucket('01:00:00'::interval, e_29."time"))) AND (e_8.device_floor = e_29.device_floor))
  • Join Filter: (((avg(e_8.event_value)) - (avg(e_29.event_value))) > '15'::double precision)
  • Rows Removed by Join Filter: 1918
  • Buffers: shared read=15320
2. 1.202 211.038 ↓ 25.0 2,147 1

Finalize GroupAggregate (cost=48,837.04..48,848.82 rows=86 width=24) (actual time=206.620..211.038 rows=2,147 loops=1)

  • Group Key: (time_bucket('01:00:00'::interval, e_8."time")), e_8.device_id, e_8.device_floor
  • Buffers: shared read=7658
3. 0.000 209.836 ↓ 30.2 2,294 1

Gather Merge (cost=48,837.04..48,846.77 rows=76 width=48) (actual time=206.608..209.836 rows=2,294 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=61 read=20968
4. 3.441 581.283 ↓ 20.1 765 3

Partial GroupAggregate (cost=47,837.02..47,837.97 rows=38 width=48) (actual time=192.466..193.761 rows=765 loops=3)

  • Group Key: (time_bucket('01:00:00'::interval, e_8."time")), e_8.device_id, e_8.device_floor
  • Buffers: shared hit=61 read=20968
5. 5.388 577.842 ↓ 40.7 1,546 3

Sort (cost=47,837.02..47,837.11 rows=38 width=24) (actual time=192.440..192.614 rows=1,546 loops=3)

  • Sort Key: (time_bucket('01:00:00'::interval, e_8."time")), e_8.device_id, e_8.device_floor
  • Sort Method: quicksort Memory: 158kB
  • Worker 0: Sort Method: quicksort Memory: 63kB
  • Worker 1: Sort Method: quicksort Memory: 348kB
  • Buffers: shared hit=61 read=20968
6. 1.932 572.454 ↓ 40.7 1,546 3

Result (cost=0.00..47,836.02 rows=38 width=24) (actual time=32.183..190.818 rows=1,546 loops=3)

  • Buffers: shared read=20961
7. 1.068 570.522 ↓ 40.7 1,546 3

Parallel Append (cost=0.00..47,835.55 rows=38 width=24) (actual time=32.180..190.174 rows=1,546 loops=3)

  • Buffers: shared read=20961
8. 59.327 59.327 ↓ 305.0 915 1

Parallel Seq Scan on _hyper_1_8_chunk e_8 (cost=0.00..5,047.71 rows=3 width=24) (actual time=0.137..59.327 rows=915 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 214623
  • Buffers: shared read=2195
9. 54.461 54.461 ↓ 55.0 220 1

Parallel Seq Scan on _hyper_1_2_chunk e_2 (cost=0.00..4,186.26 rows=4 width=24) (actual time=38.601..54.461 rows=220 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 177204
  • Buffers: shared read=1838
10. 50.411 50.411 ↓ 48.3 145 1

Parallel Seq Scan on _hyper_1_4_chunk e_4 (cost=0.00..4,124.82 rows=3 width=24) (actual time=43.204..50.411 rows=145 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 175357
  • Buffers: shared read=1802
11. 47.795 47.795 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_19_chunk e_19 (cost=0.00..3,996.70 rows=1 width=24) (actual time=47.795..47.795 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 169373
  • Buffers: shared read=1755
12. 45.265 45.265 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_12_chunk e_12 (cost=0.00..3,886.15 rows=4 width=24) (actual time=45.265..45.265 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 164496
  • Buffers: shared read=1709
13. 46.127 46.127 ↓ 301.5 1,206 1

Parallel Seq Scan on _hyper_1_5_chunk e_5 (cost=0.00..3,811.41 rows=4 width=24) (actual time=0.105..46.127 rows=1,206 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 160287
  • Buffers: shared read=1674
14. 38.847 38.847 ↓ 18.5 74 3

Parallel Seq Scan on _hyper_1_1_chunk e_1 (cost=0.00..3,292.18 rows=4 width=24) (actual time=11.090..12.949 rows=74 loops=3)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 46674
  • Buffers: shared read=1436
15. 38.312 38.312 ↓ 182.0 546 2

Parallel Seq Scan on _hyper_1_7_chunk e_7 (cost=0.00..3,228.30 rows=3 width=24) (actual time=0.061..19.156 rows=546 loops=2)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 68107
  • Buffers: shared read=1411
16. 34.464 34.464 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_10_chunk e_10 (cost=0.00..3,158.32 rows=3 width=24) (actual time=34.464..34.464 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 134211
  • Buffers: shared read=1382
17. 31.089 31.089 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_11_chunk e_11 (cost=0.00..2,850.22 rows=3 width=24) (actual time=31.089..31.089 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 121208
  • Buffers: shared read=1246
18. 26.498 26.498 ↓ 63.0 126 1

Parallel Seq Scan on _hyper_1_3_chunk e_3 (cost=0.00..2,298.77 rows=2 width=24) (actual time=21.952..26.498 rows=126 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 98910
  • Buffers: shared read=988
19. 23.873 23.873 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_13_chunk e_13 (cost=0.00..2,221.41 rows=4 width=24) (actual time=23.873..23.873 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 94324
  • Buffers: shared read=973
20. 15.258 15.258 ↓ 354.5 709 1

Parallel Seq Scan on _hyper_1_6_chunk e_6 (cost=0.00..1,291.13 rows=2 width=24) (actual time=0.053..15.258 rows=709 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 54305
  • Buffers: shared read=563
21. 11.590 11.590 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_15_chunk e_15 (cost=0.00..1,046.03 rows=4 width=24) (actual time=11.590..11.590 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 43673
  • Buffers: shared read=468
22. 10.566 10.566 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_18_chunk e_18 (cost=0.00..901.46 rows=1 width=24) (actual time=10.566..10.566 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 38266
  • Buffers: shared read=395
23. 10.387 10.387 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_14_chunk e_14 (cost=0.00..901.29 rows=1 width=24) (actual time=10.387..10.387 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 37573
  • Buffers: shared read=404
24. 11.453 11.453 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_9_chunk e_9 (cost=0.00..737.44 rows=2 width=24) (actual time=11.453..11.453 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 30860
  • Buffers: shared read=329
25. 6.656 6.656 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_16_chunk e_16 (cost=0.00..390.23 rows=2 width=24) (actual time=6.656..6.656 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 15884
  • Buffers: shared read=180
26. 3.888 3.888 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_17_chunk e_17 (cost=0.00..285.50 rows=1 width=24) (actual time=3.888..3.888 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 11749
  • Buffers: shared read=130
27. 3.186 3.186 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_20_chunk e_20 (cost=0.00..180.03 rows=1 width=24) (actual time=3.186..3.186 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 7331
  • Buffers: shared read=83
28. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on events e (cost=0.00..0.00 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
29. 0.417 201.896 ↓ 9.9 854 1

Hash (cost=48,849.39..48,849.39 rows=86 width=20) (actual time=201.895..201.896 rows=854 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 55kB
  • Buffers: shared read=7662
30. 0.956 201.479 ↓ 9.9 854 1

Finalize GroupAggregate (cost=48,837.04..48,848.53 rows=86 width=20) (actual time=199.081..201.479 rows=854 loops=1)

  • Group Key: (time_bucket('01:00:00'::interval, e_29."time")), e_29.device_floor
  • Buffers: shared read=7662
31. 0.000 200.523 ↓ 17.1 1,296 1

Gather Merge (cost=48,837.04..48,846.67 rows=76 width=44) (actual time=199.063..200.523 rows=1,296 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=60 read=20969
32. 2.352 565.431 ↓ 11.4 432 3

Partial GroupAggregate (cost=47,837.02..47,837.87 rows=38 width=44) (actual time=187.567..188.477 rows=432 loops=3)

  • Group Key: (time_bucket('01:00:00'::interval, e_29."time")), e_29.device_floor
  • Buffers: shared hit=60 read=20969
33. 4.809 563.079 ↓ 40.7 1,546 3

Sort (cost=47,837.02..47,837.11 rows=38 width=20) (actual time=187.532..187.693 rows=1,546 loops=3)

  • Sort Key: (time_bucket('01:00:00'::interval, e_29."time")), e_29.device_floor
  • Sort Method: quicksort Memory: 161kB
  • Worker 0: Sort Method: quicksort Memory: 344kB
  • Worker 1: Sort Method: quicksort Memory: 63kB
  • Buffers: shared hit=60 read=20969
34. 1.833 558.270 ↓ 40.7 1,546 3

Result (cost=0.00..47,836.02 rows=38 width=20) (actual time=28.701..186.090 rows=1,546 loops=3)

  • Buffers: shared read=20961
35. 1.010 556.437 ↓ 40.7 1,546 3

Parallel Append (cost=0.00..47,835.55 rows=38 width=20) (actual time=28.699..185.479 rows=1,546 loops=3)

  • Buffers: shared read=20961
36. 55.682 55.682 ↓ 305.0 915 1

Parallel Seq Scan on _hyper_1_8_chunk e_29 (cost=0.00..5,047.71 rows=3 width=20) (actual time=0.084..55.682 rows=915 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 214623
  • Buffers: shared read=2195
37. 50.994 50.994 ↓ 55.0 220 1

Parallel Seq Scan on _hyper_1_2_chunk e_23 (cost=0.00..4,186.26 rows=4 width=20) (actual time=35.455..50.994 rows=220 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 177204
  • Buffers: shared read=1838
38. 50.640 50.640 ↓ 48.3 145 1

Parallel Seq Scan on _hyper_1_4_chunk e_25 (cost=0.00..4,124.82 rows=3 width=20) (actual time=43.399..50.640 rows=145 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 175357
  • Buffers: shared read=1802
39. 48.310 48.310 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_19_chunk e_40 (cost=0.00..3,996.70 rows=1 width=20) (actual time=48.310..48.310 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 169373
  • Buffers: shared read=1755
40. 44.622 44.622 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_12_chunk e_33 (cost=0.00..3,886.15 rows=4 width=20) (actual time=44.622..44.622 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 164496
  • Buffers: shared read=1709
41. 45.598 45.598 ↓ 301.5 1,206 1

Parallel Seq Scan on _hyper_1_5_chunk e_26 (cost=0.00..3,811.41 rows=4 width=20) (actual time=0.094..45.598 rows=1,206 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 160287
  • Buffers: shared read=1674
42. 39.123 39.123 ↓ 18.5 74 3

Parallel Seq Scan on _hyper_1_1_chunk e_22 (cost=0.00..3,292.18 rows=4 width=20) (actual time=11.193..13.041 rows=74 loops=3)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 46674
  • Buffers: shared read=1436
43. 38.746 38.746 ↓ 182.0 546 2

Parallel Seq Scan on _hyper_1_7_chunk e_28 (cost=0.00..3,228.30 rows=3 width=20) (actual time=0.067..19.373 rows=546 loops=2)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 68107
  • Buffers: shared read=1411
44. 34.513 34.513 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_10_chunk e_31 (cost=0.00..3,158.32 rows=3 width=20) (actual time=34.513..34.513 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 134211
  • Buffers: shared read=1382
45. 30.734 30.734 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_11_chunk e_32 (cost=0.00..2,850.22 rows=3 width=20) (actual time=30.734..30.734 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 121208
  • Buffers: shared read=1246
46. 27.172 27.172 ↓ 63.0 126 1

Parallel Seq Scan on _hyper_1_3_chunk e_24 (cost=0.00..2,298.77 rows=2 width=20) (actual time=22.582..27.172 rows=126 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 98910
  • Buffers: shared read=988
47. 23.748 23.748 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_13_chunk e_34 (cost=0.00..2,221.41 rows=4 width=20) (actual time=23.748..23.748 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 94324
  • Buffers: shared read=973
48. 15.077 15.077 ↓ 354.5 709 1

Parallel Seq Scan on _hyper_1_6_chunk e_27 (cost=0.00..1,291.13 rows=2 width=20) (actual time=0.070..15.077 rows=709 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 54305
  • Buffers: shared read=563
49. 11.613 11.613 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_15_chunk e_36 (cost=0.00..1,046.03 rows=4 width=20) (actual time=11.613..11.613 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 43673
  • Buffers: shared read=468
50. 9.747 9.747 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_18_chunk e_39 (cost=0.00..901.46 rows=1 width=20) (actual time=9.747..9.747 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 38266
  • Buffers: shared read=395
51. 9.917 9.917 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_14_chunk e_35 (cost=0.00..901.29 rows=1 width=20) (actual time=9.917..9.917 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 37573
  • Buffers: shared read=404
52. 9.245 9.245 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_9_chunk e_30 (cost=0.00..737.44 rows=2 width=20) (actual time=9.245..9.245 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 30860
  • Buffers: shared read=329
53. 4.513 4.513 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_16_chunk e_37 (cost=0.00..390.23 rows=2 width=20) (actual time=4.512..4.513 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 15884
  • Buffers: shared read=180
54. 3.243 3.243 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_17_chunk e_38 (cost=0.00..285.50 rows=1 width=20) (actual time=3.243..3.243 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 11749
  • Buffers: shared read=130
55. 2.189 2.189 ↓ 0.0 0 1

Parallel Seq Scan on _hyper_1_20_chunk e_41 (cost=0.00..180.03 rows=1 width=20) (actual time=2.189..2.189 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 7331
  • Buffers: shared read=83
56. 0.001 0.001 ↓ 0.0 0 1

Parallel Seq Scan on events e_21 (cost=0.00..0.00 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (((event_type)::text = 'temperature'::text) AND (date("time") >= '2016-12-07'::date) AND (date("time") <= '2016-12-14 00:00:00'::timestamp without time zone))