Skip to main content

Top Queries Execution Time

  1. The third chart in the bottom section, shows the load on the PostgreSQL database system, in terms of overall amount of time taken by each query in a database.
  2. Each bar represents the overall time taken by a query i.e. sum all of its execution times.
  3. The load is measured in terms of units of time taken by a query to execute.
  4. The X-axis represents the query identifier and the Y-axis represents the time taken to execute.
  5. Hover over the bar for more information.
  6. Longer the peak of the bar, more time a query has taken.
  7. If you feel like any query shouldn't have consumed as much time in all its executions, fine tune it as necessary.

Peeking into the query

  • Click on the query identifier visible in X-axis.
  • A new view opens up with the complete query text, under the Query Text tab.
  • To view the execution plan of the query, click on the Query Plans tab.