explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N1TO

Settings
# exclusive inclusive rows x rows loops node
1. 525.530 43,811.855 ↓ 376.1 115,098 1

Nested Loop (cost=129,897.04..20,832,146.81 rows=306 width=849) (actual time=4,533.982..43,811.855 rows=115,098 loops=1)

  • Functions: 852
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 71.209 ms, Inlining 18.546 ms, Optimization 2439.119 ms, Emission 1854.736 ms, Total 4383.611 ms"Execution Time: 43,902.450 ms
2. 157.648 4,616.085 ↓ 1.9 115,090 1

HashAggregate (cost=129,896.60..132,191.99 rows=61,210 width=20) (actual time=4,532.889..4,616.085 rows=115,090 loops=1)

  • Group Key: _hyper_1_101_chunk."timestamp", _hyper_1_101_chunk.machine_name
  • Filter: (count(*) > 1)
3. 21.271 4,458.437 ↓ 1.3 230,188 1

Result (cost=0.43..128,060.29 rows=183,631 width=20) (actual time=4,315.665..4,458.437 rows=230,188 loops=1)

4. 4,437.166 4,437.166 ↓ 1.3 230,188 1

Index Scan using _hyper_1_101_chunk_machine_telemetry_timestamp_idx on _hyper_1_101_chunk (cost=0.43..126,223.98 rows=183,631 width=20) (actual time=4,315.642..4,437.166 rows=230,188 loops=1)

  • Index Cond: (("timestamp" >= '2017-12-17 01:00:00+00'::timestamp with time zone) AND ("timestamp" <= '2017-12-18 01:00:00+00'::timestamp with time zone))
5. 5,063.960 38,670.240 ↑ 123.0 1 115,090

Append (cost=0.43..336.94 rows=123 width=835) (actual time=0.292..0.336 rows=1 loops=115,090)

6. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "1_1_machine_telemetry_pkey" on _hyper_1_1_chunk a (cost=0.43..2.69 rows=1 width=825) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
7. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "2_3_machine_telemetry_pkey" on _hyper_1_2_chunk a_1 (cost=0.56..2.74 rows=1 width=806) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
8. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "3_5_machine_telemetry_pkey" on _hyper_1_3_chunk a_2 (cost=0.56..2.78 rows=1 width=826) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
9. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "4_7_machine_telemetry_pkey" on _hyper_1_4_chunk a_3 (cost=0.56..2.81 rows=1 width=844) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
10. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "5_9_machine_telemetry_pkey" on _hyper_1_5_chunk a_4 (cost=0.56..2.94 rows=1 width=816) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
11. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "6_11_machine_telemetry_pkey" on _hyper_1_6_chunk a_5 (cost=0.56..2.77 rows=1 width=815) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
12. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "7_13_machine_telemetry_pkey" on _hyper_1_7_chunk a_6 (cost=0.56..2.77 rows=1 width=816) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
13. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "8_15_machine_telemetry_pkey" on _hyper_1_8_chunk a_7 (cost=0.56..2.85 rows=1 width=818) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
14. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "9_17_machine_telemetry_pkey" on _hyper_1_9_chunk a_8 (cost=0.56..2.85 rows=1 width=832) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
15. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "10_19_machine_telemetry_pkey" on _hyper_1_10_chunk a_9 (cost=0.56..2.83 rows=1 width=835) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
16. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "11_21_machine_telemetry_pkey" on _hyper_1_11_chunk a_10 (cost=0.56..2.80 rows=1 width=848) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
17. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "12_23_machine_telemetry_pkey" on _hyper_1_12_chunk a_11 (cost=0.56..2.82 rows=1 width=875) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
18. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "13_25_machine_telemetry_pkey" on _hyper_1_13_chunk a_12 (cost=0.56..2.83 rows=1 width=842) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
19. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "14_27_machine_telemetry_pkey" on _hyper_1_14_chunk a_13 (cost=0.56..2.84 rows=1 width=855) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
20. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "15_29_machine_telemetry_pkey" on _hyper_1_15_chunk a_14 (cost=0.56..2.84 rows=1 width=844) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
21. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "16_31_machine_telemetry_pkey" on _hyper_1_16_chunk a_15 (cost=0.56..2.83 rows=1 width=832) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
22. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "17_33_machine_telemetry_pkey" on _hyper_1_17_chunk a_16 (cost=0.56..2.95 rows=1 width=848) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
23. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "18_35_machine_telemetry_pkey" on _hyper_1_18_chunk a_17 (cost=0.56..2.84 rows=1 width=851) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
24. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "19_37_machine_telemetry_pkey" on _hyper_1_19_chunk a_18 (cost=0.56..2.85 rows=1 width=827) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
25. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "20_39_machine_telemetry_pkey" on _hyper_1_20_chunk a_19 (cost=0.56..2.80 rows=1 width=836) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
26. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "21_41_machine_telemetry_pkey" on _hyper_1_21_chunk a_20 (cost=0.56..2.83 rows=1 width=840) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
27. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "22_43_machine_telemetry_pkey" on _hyper_1_22_chunk a_21 (cost=0.56..2.80 rows=1 width=843) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
28. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "23_45_machine_telemetry_pkey" on _hyper_1_23_chunk a_22 (cost=0.56..2.83 rows=1 width=833) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
29. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "24_47_machine_telemetry_pkey" on _hyper_1_24_chunk a_23 (cost=0.56..2.83 rows=1 width=837) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
30. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "25_49_machine_telemetry_pkey" on _hyper_1_25_chunk a_24 (cost=0.56..2.85 rows=1 width=821) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
31. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "26_51_machine_telemetry_pkey" on _hyper_1_26_chunk a_25 (cost=0.56..2.84 rows=1 width=828) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
32. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "27_53_machine_telemetry_pkey" on _hyper_1_27_chunk a_26 (cost=0.56..2.75 rows=1 width=824) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
33. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "28_55_machine_telemetry_pkey" on _hyper_1_28_chunk a_27 (cost=0.56..2.85 rows=1 width=845) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
34. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "29_57_machine_telemetry_pkey" on _hyper_1_29_chunk a_28 (cost=0.56..2.83 rows=1 width=845) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
35. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "30_59_machine_telemetry_pkey" on _hyper_1_30_chunk a_29 (cost=0.56..2.82 rows=1 width=852) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
36. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "31_61_machine_telemetry_pkey" on _hyper_1_31_chunk a_30 (cost=0.56..2.83 rows=1 width=851) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
37. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "32_63_machine_telemetry_pkey" on _hyper_1_32_chunk a_31 (cost=0.56..2.82 rows=1 width=815) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
38. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "33_65_machine_telemetry_pkey" on _hyper_1_33_chunk a_32 (cost=0.56..2.77 rows=1 width=851) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
39. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "34_67_machine_telemetry_pkey" on _hyper_1_34_chunk a_33 (cost=0.56..2.77 rows=1 width=828) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
40. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "35_69_machine_telemetry_pkey" on _hyper_1_35_chunk a_34 (cost=0.56..2.83 rows=1 width=856) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
41. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "36_71_machine_telemetry_pkey" on _hyper_1_36_chunk a_35 (cost=0.56..2.83 rows=1 width=832) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
42. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "37_73_machine_telemetry_pkey" on _hyper_1_37_chunk a_36 (cost=0.56..2.80 rows=1 width=842) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
43. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "38_75_machine_telemetry_pkey" on _hyper_1_38_chunk a_37 (cost=0.56..2.83 rows=1 width=826) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
44. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "39_77_machine_telemetry_pkey" on _hyper_1_39_chunk a_38 (cost=0.56..2.85 rows=1 width=809) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
45. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "40_79_machine_telemetry_pkey" on _hyper_1_40_chunk a_39 (cost=0.56..2.84 rows=1 width=816) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
46. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "41_81_machine_telemetry_pkey" on _hyper_1_41_chunk a_40 (cost=0.56..2.84 rows=1 width=818) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
47. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "42_83_machine_telemetry_pkey" on _hyper_1_42_chunk a_41 (cost=0.56..2.86 rows=1 width=850) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
48. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "43_85_machine_telemetry_pkey" on _hyper_1_43_chunk a_42 (cost=0.56..2.79 rows=1 width=832) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
49. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "44_87_machine_telemetry_pkey" on _hyper_1_44_chunk a_43 (cost=0.56..2.84 rows=1 width=809) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
50. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "45_89_machine_telemetry_pkey" on _hyper_1_45_chunk a_44 (cost=0.56..2.84 rows=1 width=829) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
51. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "46_91_machine_telemetry_pkey" on _hyper_1_46_chunk a_45 (cost=0.56..2.84 rows=1 width=816) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
52. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "47_93_machine_telemetry_pkey" on _hyper_1_47_chunk a_46 (cost=0.56..2.83 rows=1 width=852) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
53. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "48_95_machine_telemetry_pkey" on _hyper_1_48_chunk a_47 (cost=0.56..2.83 rows=1 width=844) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
54. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "49_97_machine_telemetry_pkey" on _hyper_1_49_chunk a_48 (cost=0.56..2.82 rows=1 width=832) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
55. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "50_99_machine_telemetry_pkey" on _hyper_1_50_chunk a_49 (cost=0.56..2.79 rows=1 width=855) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
56. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "51_101_machine_telemetry_pkey" on _hyper_1_51_chunk a_50 (cost=0.56..2.80 rows=1 width=845) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
57. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "52_103_machine_telemetry_pkey" on _hyper_1_52_chunk a_51 (cost=0.56..2.84 rows=1 width=849) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
58. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "53_105_machine_telemetry_pkey" on _hyper_1_53_chunk a_52 (cost=0.56..2.78 rows=1 width=836) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
59. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "54_107_machine_telemetry_pkey" on _hyper_1_54_chunk a_53 (cost=0.56..2.82 rows=1 width=836) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
60. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "55_109_machine_telemetry_pkey" on _hyper_1_55_chunk a_54 (cost=0.56..2.77 rows=1 width=849) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
61. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "56_111_machine_telemetry_pkey" on _hyper_1_56_chunk a_55 (cost=0.56..6.65 rows=4 width=710) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
62. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "57_113_machine_telemetry_pkey" on _hyper_1_57_chunk a_56 (cost=0.56..2.77 rows=1 width=838) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
63. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "58_115_machine_telemetry_pkey" on _hyper_1_58_chunk a_57 (cost=0.56..2.84 rows=1 width=829) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
64. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "59_117_machine_telemetry_pkey" on _hyper_1_59_chunk a_58 (cost=0.56..2.78 rows=1 width=834) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
65. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "60_119_machine_telemetry_pkey" on _hyper_1_60_chunk a_59 (cost=0.56..2.77 rows=1 width=845) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
66. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "61_121_machine_telemetry_pkey" on _hyper_1_61_chunk a_60 (cost=0.56..2.78 rows=1 width=844) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
67. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "62_123_machine_telemetry_pkey" on _hyper_1_62_chunk a_61 (cost=0.56..2.77 rows=1 width=829) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
68. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "63_125_machine_telemetry_pkey" on _hyper_1_63_chunk a_62 (cost=0.56..2.75 rows=1 width=791) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
69. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "64_127_machine_telemetry_pkey" on _hyper_1_64_chunk a_63 (cost=0.56..2.84 rows=1 width=808) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
70. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "65_129_machine_telemetry_pkey" on _hyper_1_65_chunk a_64 (cost=0.56..2.83 rows=1 width=874) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
71. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "66_131_machine_telemetry_pkey" on _hyper_1_66_chunk a_65 (cost=0.56..2.80 rows=1 width=867) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
72. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "67_133_machine_telemetry_pkey" on _hyper_1_67_chunk a_66 (cost=0.56..2.84 rows=1 width=822) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
73. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "68_135_machine_telemetry_pkey" on _hyper_1_68_chunk a_67 (cost=0.56..2.83 rows=1 width=829) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
74. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "69_137_machine_telemetry_pkey" on _hyper_1_69_chunk a_68 (cost=0.56..2.77 rows=1 width=852) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
75. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "70_139_machine_telemetry_pkey" on _hyper_1_70_chunk a_69 (cost=0.56..2.89 rows=1 width=863) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
76. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "71_141_machine_telemetry_pkey" on _hyper_1_71_chunk a_70 (cost=0.56..2.84 rows=1 width=849) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
77. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "72_143_machine_telemetry_pkey" on _hyper_1_72_chunk a_71 (cost=0.56..2.77 rows=1 width=815) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
78. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "73_145_machine_telemetry_pkey" on _hyper_1_73_chunk a_72 (cost=0.56..2.81 rows=1 width=820) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
79. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "74_147_machine_telemetry_pkey" on _hyper_1_74_chunk a_73 (cost=0.56..2.87 rows=1 width=801) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
80. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "75_149_machine_telemetry_pkey" on _hyper_1_75_chunk a_74 (cost=0.56..2.91 rows=1 width=838) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
81. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "76_151_machine_telemetry_pkey" on _hyper_1_76_chunk a_75 (cost=0.56..2.81 rows=1 width=833) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
82. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "77_153_machine_telemetry_pkey" on _hyper_1_77_chunk a_76 (cost=0.56..2.82 rows=1 width=813) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
83. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "78_155_machine_telemetry_pkey" on _hyper_1_78_chunk a_77 (cost=0.56..2.88 rows=1 width=833) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
84. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "79_157_machine_telemetry_pkey" on _hyper_1_79_chunk a_78 (cost=0.56..2.84 rows=1 width=826) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
85. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "80_159_machine_telemetry_pkey" on _hyper_1_80_chunk a_79 (cost=0.56..2.85 rows=1 width=818) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
86. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "81_161_machine_telemetry_pkey" on _hyper_1_81_chunk a_80 (cost=0.56..2.84 rows=1 width=840) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
87. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "82_163_machine_telemetry_pkey" on _hyper_1_82_chunk a_81 (cost=0.56..2.82 rows=1 width=841) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
88. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "83_165_machine_telemetry_pkey" on _hyper_1_83_chunk a_82 (cost=0.56..2.77 rows=1 width=860) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
89. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "84_167_machine_telemetry_pkey" on _hyper_1_84_chunk a_83 (cost=0.56..2.79 rows=1 width=837) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
90. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "85_169_machine_telemetry_pkey" on _hyper_1_85_chunk a_84 (cost=0.43..2.60 rows=1 width=843) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
91. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "86_171_machine_telemetry_pkey" on _hyper_1_86_chunk a_85 (cost=0.56..2.84 rows=1 width=838) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
92. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "87_173_machine_telemetry_pkey" on _hyper_1_87_chunk a_86 (cost=0.56..2.78 rows=1 width=831) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
93. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "88_175_machine_telemetry_pkey" on _hyper_1_88_chunk a_87 (cost=0.56..2.78 rows=1 width=837) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
94. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "89_177_machine_telemetry_pkey" on _hyper_1_89_chunk a_88 (cost=0.56..2.78 rows=1 width=848) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
95. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "90_179_machine_telemetry_pkey" on _hyper_1_90_chunk a_89 (cost=0.56..2.86 rows=1 width=849) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
96. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "91_181_machine_telemetry_pkey" on _hyper_1_91_chunk a_90 (cost=0.56..2.75 rows=1 width=842) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
97. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "92_183_machine_telemetry_pkey" on _hyper_1_92_chunk a_91 (cost=0.56..2.79 rows=1 width=810) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
98. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "93_185_machine_telemetry_pkey" on _hyper_1_93_chunk a_92 (cost=0.56..2.79 rows=1 width=814) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
99. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "94_187_machine_telemetry_pkey" on _hyper_1_94_chunk a_93 (cost=0.56..2.85 rows=1 width=819) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
100. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "95_189_machine_telemetry_pkey" on _hyper_1_95_chunk a_94 (cost=0.56..2.79 rows=1 width=842) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
101. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "96_191_machine_telemetry_pkey" on _hyper_1_96_chunk a_95 (cost=0.56..2.75 rows=1 width=858) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
102. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "97_193_machine_telemetry_pkey" on _hyper_1_97_chunk a_96 (cost=0.56..2.76 rows=1 width=827) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
103. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "98_195_machine_telemetry_pkey" on _hyper_1_98_chunk a_97 (cost=0.56..2.86 rows=1 width=867) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
104. 345.270 345.270 ↓ 0.0 0 115,090

Index Scan using "99_197_machine_telemetry_pkey" on _hyper_1_99_chunk a_98 (cost=0.56..2.83 rows=1 width=837) (actual time=0.003..0.003 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
105. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "100_199_machine_telemetry_pkey" on _hyper_1_100_chunk a_99 (cost=0.43..2.63 rows=1 width=876) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
106. 805.630 805.630 ↑ 1.0 1 115,090

Index Scan using "101_201_machine_telemetry_pkey" on _hyper_1_101_chunk a_100 (cost=0.43..2.60 rows=1 width=880) (actual time=0.007..0.007 rows=1 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
  • Rows Removed by Filter: 1
107. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "102_203_machine_telemetry_pkey" on _hyper_1_102_chunk a_101 (cost=0.43..2.60 rows=1 width=863) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
108. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "103_205_machine_telemetry_pkey" on _hyper_1_103_chunk a_102 (cost=0.29..2.44 rows=1 width=823) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
109. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "104_207_machine_telemetry_pkey" on _hyper_1_104_chunk a_103 (cost=0.43..2.60 rows=1 width=846) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
110. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "105_209_machine_telemetry_pkey" on _hyper_1_105_chunk a_104 (cost=0.43..2.60 rows=1 width=865) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
111. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "111_217_machine_telemetry_pkey" on _hyper_1_111_chunk a_105 (cost=0.42..2.58 rows=1 width=1,621) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
112. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "112_219_machine_telemetry_pkey" on _hyper_1_112_chunk a_106 (cost=0.42..2.58 rows=1 width=1,621) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
113. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using _hyper_1_113_chunk_machine_telemetry_timestamp_idx on _hyper_1_113_chunk a_107 (cost=0.42..2.58 rows=1 width=1,622) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: ("timestamp" = _hyper_1_101_chunk."timestamp")
  • Filter: ((ctid <> (min(_hyper_1_101_chunk.ctid))) AND (_hyper_1_101_chunk.machine_name = machine_name))
114. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using _hyper_1_114_chunk_machine_telemetry_timestamp_idx on _hyper_1_114_chunk a_108 (cost=0.42..2.59 rows=1 width=1,259) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: ("timestamp" = _hyper_1_101_chunk."timestamp")
  • Filter: ((ctid <> (min(_hyper_1_101_chunk.ctid))) AND (_hyper_1_101_chunk.machine_name = machine_name))
115. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using _hyper_1_115_chunk_machine_telemetry_timestamp_idx on _hyper_1_115_chunk a_109 (cost=0.42..2.59 rows=1 width=1,261) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: ("timestamp" = _hyper_1_101_chunk."timestamp")
  • Filter: ((ctid <> (min(_hyper_1_101_chunk.ctid))) AND (_hyper_1_101_chunk.machine_name = machine_name))
116. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "116_227_machine_telemetry_pkey" on _hyper_1_116_chunk a_110 (cost=0.42..2.60 rows=1 width=1,261) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
117. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "117_229_machine_telemetry_pkey" on _hyper_1_117_chunk a_111 (cost=0.43..2.62 rows=1 width=1,261) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
118. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "118_231_machine_telemetry_pkey" on _hyper_1_118_chunk a_112 (cost=0.43..2.60 rows=1 width=975) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
119. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "119_233_machine_telemetry_pkey" on _hyper_1_119_chunk a_113 (cost=0.42..2.62 rows=1 width=1,260) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
120. 115.090 115.090 ↓ 0.0 0 115,090

Index Scan using _hyper_1_120_chunk_machine_telemetry_timestamp_idx on _hyper_1_120_chunk a_114 (cost=0.27..2.16 rows=1 width=312) (actual time=0.001..0.001 rows=0 loops=115,090)

  • Index Cond: ("timestamp" = _hyper_1_101_chunk."timestamp")
  • Filter: ((ctid <> (min(_hyper_1_101_chunk.ctid))) AND (_hyper_1_101_chunk.machine_name = machine_name))
121. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "121_237_machine_telemetry_pkey" on _hyper_1_121_chunk a_115 (cost=0.42..2.58 rows=1 width=720) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
122. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using "122_239_machine_telemetry_pkey" on _hyper_1_122_chunk a_116 (cost=0.42..2.60 rows=1 width=819) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: (("timestamp" = _hyper_1_101_chunk."timestamp") AND (machine_name = _hyper_1_101_chunk.machine_name))
  • Filter: (ctid <> (min(_hyper_1_101_chunk.ctid)))
123. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using _hyper_1_123_chunk_machine_telemetry_timestamp_idx on _hyper_1_123_chunk a_117 (cost=0.42..2.58 rows=1 width=749) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: ("timestamp" = _hyper_1_101_chunk."timestamp")
  • Filter: ((ctid <> (min(_hyper_1_101_chunk.ctid))) AND (_hyper_1_101_chunk.machine_name = machine_name))
124. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using _hyper_1_124_chunk_machine_telemetry_timestamp_idx on _hyper_1_124_chunk a_118 (cost=0.42..2.58 rows=1 width=922) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: ("timestamp" = _hyper_1_101_chunk."timestamp")
  • Filter: ((ctid <> (min(_hyper_1_101_chunk.ctid))) AND (_hyper_1_101_chunk.machine_name = machine_name))
125. 230.180 230.180 ↓ 0.0 0 115,090

Index Scan using _hyper_1_125_chunk_machine_telemetry_timestamp_idx on _hyper_1_125_chunk a_119 (cost=0.42..2.58 rows=1 width=716) (actual time=0.002..0.002 rows=0 loops=115,090)

  • Index Cond: ("timestamp" = _hyper_1_101_chunk."timestamp")
  • Filter: ((ctid <> (min(_hyper_1_101_chunk.ctid))) AND (_hyper_1_101_chunk.machine_name = machine_name))