Troubleshooting

To troubleshoot a query, you can examine its EXPLAIN plan.

To understand the query performance on a hypertable, we suggest first making sure that the planner statistics and table maintenance is up-to-date on the hypertable by running . Then, we suggest running the following version of EXPLAIN:

When asking query-performance related questions in our or via slack, providing the EXPLAIN output of a query is immensely helpful.