Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • Please. Always. Provide. Your. Version. Of. Postgres. SELECT version(); (I have posted like a thousand variations of this comment over the years, if you wonder about the punctuation.) Commented Dec 16, 2021 at 10:47
  • sorry for that, i've added it on the original post. Commented Dec 16, 2021 at 10:53
  • Are these timings consistently repeatable? And what is the index definition? Commented Dec 17, 2021 at 7:35
  • No, those timings are not repeatable, they can differs from time to time. the indexes are insert_time desc in tv_event table and clustered smart_device_id, smart_device_id + insert time desc on the tv_smartdevicemeasurementsnmp table Commented Dec 17, 2021 at 10:02