Database Reference
In-Depth Information
LOG: long duration
Queries that take longer than 2 seconds are logged automatically so that you can identify
and optimize your code. These logs are generated in the following format:
[8-2] g0afa5bjht [GOLD] LOG: duration: 63.697 ms statement:
SELECT "courses".* FROM "courses"...
If there are large numbers of these logs, probably your application has performance prob-
lems. A good recommendation is to try to reduce the execution time of your queries by 10
ms. You can achieve this optimization by adding indexes or using the
EXPLAIN
command
from PostgreSQL to understand the performance issues in your query.
