explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pmgh

Settings
# exclusive inclusive rows x rows loops node
1. 0.035 242,624.915 ↑ 1.0 1 1

Limit (cost=0.15..7.93 rows=1 width=24) (actual time=242,624.881..242,624.915 rows=1 loops=1)

2. 0.004 242,624.880 ↑ 3.0 1 1

Custom Scan (ChunkAppend) on "timelineRawEvents" (cost=0.15..23.50 rows=3 width=24) (actual time=242,624.879..242,624.880 rows=1 loops=1)

  • Order: "timelineRawEvents"."timestamp" DESC
3. 0.019 0.019 ↓ 0.0 0 1

Index Scan using "_hyper_1_66_chunk_timelineRawEvents_timestamp_idx" on _hyper_1_66_chunk (cost=0.15..23.50 rows=3 width=24) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
  • Rows Removed by Filter: 5
4. 213.346 213.346 ↓ 0.0 0 1

Index Scan using "_hyper_1_77_chunk_timelineRawEvents_timestamp_idx" on _hyper_1_77_chunk (cost=0.42..31,360.04 rows=41 width=24) (actual time=213.346..213.346 rows=0 loops=1)

  • Filter: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
  • Rows Removed by Filter: 489586
5. 242,411.511 242,411.511 ↑ 128.0 1 1

Index Scan using "_hyper_1_75_chunk_timelineRawEvents_timestamp_idx" on _hyper_1_75_chunk (cost=0.43..166,892.32 rows=128 width=24) (actual time=242,411.511..242,411.511 rows=1 loops=1)

  • Filter: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
  • Rows Removed by Filter: 2506966
6. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_73_chunk."timestamp" DESC
7. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_73_chunk (cost=1.17..3.51 rows=3,000 width=24) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_76_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_76_chunk (cost=0.28..3.51 rows=3 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
9. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_71_chunk."timestamp" DESC
10. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_71_chunk (cost=1.00..4.00 rows=4,000 width=24) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_74_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_74_chunk (cost=0.28..4.00 rows=4 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
12. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_69_chunk."timestamp" DESC
13. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_69_chunk (cost=1.00..4.00 rows=4,000 width=24) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_72_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_72_chunk (cost=0.28..4.00 rows=4 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
15. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_67_chunk."timestamp" DESC
16. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_67_chunk (cost=2.50..2.50 rows=1,000 width=24) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_70_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_70_chunk (cost=0.28..2.50 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
18. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_64_chunk."timestamp" DESC
19. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_64_chunk (cost=1.00..4.00 rows=4,000 width=24) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_68_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_68_chunk (cost=0.28..4.00 rows=4 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
21. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_62_chunk."timestamp" DESC
22. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_62_chunk (cost=0.80..5.62 rows=7,000 width=24) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_65_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_65_chunk (cost=0.28..5.62 rows=7 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
24. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_60_chunk."timestamp" DESC
25. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_60_chunk (cost=1.18..3.53 rows=3,000 width=24) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_63_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_63_chunk (cost=0.28..3.53 rows=3 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
27. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_58_chunk."timestamp" DESC
28. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_58_chunk (cost=1.17..3.50 rows=3,000 width=24) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_61_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_61_chunk (cost=0.28..3.50 rows=3 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
30. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_56_chunk."timestamp" DESC
31. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_56_chunk (cost=1.00..4.02 rows=4,000 width=24) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_59_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_59_chunk (cost=0.28..4.02 rows=4 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
33. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_54_chunk."timestamp" DESC
34. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_54_chunk (cost=1.00..4.02 rows=4,000 width=24) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_57_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_57_chunk (cost=0.28..4.02 rows=4 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
36. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_52_chunk."timestamp" DESC
37. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_52_chunk (cost=0.76..6.08 rows=8,000 width=24) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_55_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_55_chunk (cost=0.28..6.08 rows=8 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
39. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_50_chunk."timestamp" DESC
40. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_50_chunk (cost=0.76..6.07 rows=8,000 width=24) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_53_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_53_chunk (cost=0.28..6.07 rows=8 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
42. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_48_chunk."timestamp" DESC
43. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_48_chunk (cost=0.79..5.53 rows=7,000 width=24) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_51_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_51_chunk (cost=0.28..5.53 rows=7 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
45. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_46_chunk."timestamp" DESC
46. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_46_chunk (cost=1.17..3.50 rows=3,000 width=24) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_49_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_49_chunk (cost=0.28..3.50 rows=3 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
48. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_44_chunk."timestamp" DESC
49. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_44_chunk (cost=2.50..2.50 rows=1,000 width=24) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_47_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_47_chunk (cost=0.28..2.50 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
51. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_42_chunk."timestamp" DESC
52. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_42_chunk (cost=2.50..2.50 rows=1,000 width=24) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_45_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_45_chunk (cost=0.28..2.50 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
54. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_21_chunk."timestamp" DESC
55. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_21_chunk (cost=2.36..2.36 rows=1,000 width=24) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_43_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_43_chunk (cost=0.14..2.36 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
57. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_20_chunk."timestamp" DESC
58. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_20_chunk (cost=2.36..2.36 rows=1,000 width=24) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_41_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_41_chunk (cost=0.14..2.36 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
60. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_19_chunk."timestamp" DESC
61. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_19_chunk (cost=2.36..2.36 rows=1,000 width=24) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_40_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_40_chunk (cost=0.14..2.36 rows=1 width=160) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
63. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_18_chunk."timestamp" DESC
64. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_18_chunk (cost=1.39..1.39 rows=1,000 width=24) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Seq Scan on compress_hyper_2_39_chunk (cost=0.00..1.39 rows=1 width=160) (never executed)

  • Filter: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
66. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_17_chunk."timestamp" DESC
67. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_17_chunk (cost=1.41..1.41 rows=1,000 width=24) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Seq Scan on compress_hyper_2_38_chunk (cost=0.00..1.41 rows=1 width=160) (never executed)

  • Filter: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
69. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_16_chunk."timestamp" DESC
70. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_16_chunk (cost=1.25..1.25 rows=1,000 width=24) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Seq Scan on compress_hyper_2_37_chunk (cost=0.00..1.25 rows=1 width=160) (never executed)

  • Filter: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
72. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_15_chunk."timestamp" DESC
73. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_15_chunk (cost=1.04..1.04 rows=1,000 width=24) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Seq Scan on compress_hyper_2_36_chunk (cost=0.00..1.04 rows=1 width=160) (never executed)

  • Filter: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
75. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_14_chunk."timestamp" DESC
76. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_14_chunk (cost=1.02..1.02 rows=1,000 width=24) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Seq Scan on compress_hyper_2_35_chunk (cost=0.00..1.02 rows=1 width=160) (never executed)

  • Filter: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
78. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_13_chunk."timestamp" DESC
79. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_13_chunk (cost=1.01..1.01 rows=1,000 width=24) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Seq Scan on compress_hyper_2_34_chunk (cost=0.00..1.01 rows=1 width=160) (never executed)

  • Filter: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
81. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_12_chunk."timestamp" DESC
82. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_12_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_33_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_33_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
84. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_11_chunk."timestamp" DESC
85. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_11_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_32_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_32_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
87. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_10_chunk."timestamp" DESC
88. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_10_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_31_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_31_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
90. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_9_chunk."timestamp" DESC
91. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_9_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_30_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_30_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
93. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_8_chunk."timestamp" DESC
94. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_8_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_29_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_29_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
96. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_7_chunk."timestamp" DESC
97. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_7_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_28_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_28_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
99. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_6_chunk."timestamp" DESC
100. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_6_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_27_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_27_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
102. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_4_chunk."timestamp" DESC
103. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_4_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_26_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_26_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
105. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_3_chunk."timestamp" DESC
106. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_3_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_25_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_25_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
108. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_2_chunk."timestamp" DESC
109. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_2_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_24_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_24_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
111. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_1_chunk."timestamp" DESC
112. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_1_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_23_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_23_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
114. 0.000 0.000 ↓ 0.0 0

Sort (cost=0.00..0.00 rows=0 width=0) (never executed)

  • Sort Key: _hyper_1_5_chunk."timestamp" DESC
115. 0.000 0.000 ↓ 0.0 0

Custom Scan (DecompressChunk) on _hyper_1_5_chunk (cost=2.37..2.37 rows=1,000 width=24) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Index Scan using "compress_hyper_2_22_chunk__compressed_hypertable_2_userId__ts_m" on compress_hyper_2_22_chunk (cost=0.15..2.37 rows=1 width=84) (never executed)

  • Index Cond: ("userId" = 'f0040429-bf11-41e4-9f0d-42936f79c789'::uuid)
Planning time : 281.797 ms
Execution time : 242,627.683 ms