Post #2847216

@cjwatson@mastodon.ie You can make tests based on execution time of the query. I usually not try this approch because you probably want some sintetic data so the time is not influenced by data size. I usually prefer a simple test on how much time it take in execution, with a reasonable time limit, just to catch extreme cases. I agree that taking a look at query plan is more deterministic, but still you can have false positive, that you need to evaluete from time to time. Seq scan can be faster than index access, it depends in data size, or result set size.