PostgreSQL query very slow with limit 1

You can avoid this issue by adding an unneeded ORDER BY clause to the query.

SELECT * FROM object_values WHERE (objectID = 53708) ORDER BY timestamp, objectID DESC limit 1;

Related Contents:

  1. PostgreSQL LIKE query performance variations
  2. Optimize Postgres query on timestamp range
  3. Postgres query optimization (forcing an index scan)
  4. Function executes faster without STRICT modifier?
  5. The infamous java.sql.SQLException: No suitable driver found
  6. How to import CSV file data into a PostgreSQL table
  7. Calculating and saving space in PostgreSQL
  8. PostgreSQL function for last inserted ID
  9. PostgreSQL error: Fatal: role “username” does not exist
  10. What are ‘$$’ used for in PL/pgSQL
  11. Optimise PostgreSQL for fast testing
  12. Store common query as column?
  13. How can I drop all the tables in a PostgreSQL database?
  14. Why does PostgreSQL perform sequential scan on indexed column?
  15. Normalize array subscripts so they start with 1
  16. Postgresql: Conditionally unique constraint
  17. How to export table as CSV with headings on Postgresql?
  18. I forgot the password I entered during postgres installation
  19. PostgreSQL naming conventions
  20. Where does PostgreSQL store configuration/conf files?
  21. Using row_to_json() with nested joins
  22. How to thoroughly purge and reinstall postgresql on ubuntu? [closed]
  23. Permission denied for relation
  24. Postgres: check if array field contains value?
  25. Postgresql SQL GROUP BY time interval with arbitrary accuracy (down to milli seconds)
  26. PostgreSQL array of elements that each are a foreign key
  27. How to make connection to Postgres via Node.js
  28. How to add “on delete cascade” constraints?
  29. Postgresql Truncation speed
  30. How to reset sequence in postgres and fill id column with new data?
  31. Is there a way to disable function overloading in Postgres
  32. PostgreSQL – max number of parameters in “IN” clause?
  33. PostgreSQL: Why psql can’t connect to server?
  34. docker postgres pgadmin local connection
  35. Using pyspark to connect to PostgreSQL
  36. PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
  37. PostgreSQL – fetch the rows which have the Max value for a column in each GROUP BY group
  38. Psql could not connect to server: No such file or directory, 5432 error?
  39. Postgres: Distinct but only for one column
  40. SQLAlchemy, Psycopg2 and Postgresql COPY
  41. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  42. Change type of varchar field to integer: “cannot be cast automatically to type integer”
  43. Find difference between timestamps in seconds in PostgreSQL
  44. Get execution time of PostgreSQL query
  45. Insert if not exists, else return id in postgresql
  46. In PostgreSQL, how to insert data with COPY command?
  47. Subquery v/s inner join in sql server
  48. function returns multiple columns as a single column instead of multiple columns
  49. Return SETOF rows from PostgreSQL function
  50. How to add column if not exists on PostgreSQL?

Leave a Comment