{{template "header.tpl" .}} {{template "server/navbar.tpl" .}} {{template "server/sidebar.tpl" .}}

Query

Executed by user {{.User}} on database {{.Database}}:

{{.Query}}

copy to clipboard

On the average this query takes {{.AvgTime}} to execute, including {{.DiskReadTime}} for disk read and {{.DiskWriteTime}} for disk write. It reads {{.DiskReadBytes}} from disk, {{.SharedBufBytes}} from the shared buffer cache and {{.LocalBufBytes}} from the local buffer cache. It causes a synchronous disk write of {{.DiskWriteBytes}}. It writes out {{.TempWriteBytes}} into temporary files and reads in {{.TempReadBytes}}.

{{if ge .PGVersion 130000}} {{end}}
Total Calls{{.Calls}}
Execution Time {{.MinTime}} min, {{.AvgTime}} avg, {{.MaxTime}} max
Total Time Spent Executing This Query{{.TotalTime}}
Rows Returned {{.RowsPerCall}} per call, {{.Rows}} total
WAL Records {{.WALRecordsPerCall}} per call, {{.WALRecords}} total
WAL Bytes {{.WALBytesPerCall}} per call, {{.WALBytes}} total

Execution Plan

{{if .Schema17}} {{if .Plan}}

{{.Plan}}

This plan was logged at .
{{else}}
No query execution plans were found for this query. Learn more.
{{end}} {{else}} {{end}} {{if (and .Schema17 .Plan .SampleQuery)}}
Sample Query

{{.SampleQuery}}

This is the query that corresponds to the execution plan shown above.
{{end}}

Slow Query Suggestions

{{if .Schema17}} {{if .Plan}} {{if .Suggestions}} {{range .Suggestions}} {{end}}
Observation Suggestion
{{index . 0}} {{index . 1}}
{{else}}
No suggestions are currently available for this query.
{{end}} {{else}}
No query execution plans were found for this query. Learn more.
{{end}} {{else}} {{end}}
units:
{{template "server/delete-modal.tpl" .}} {{template "server/sharing-modal.tpl" .}} {{template "footer-pre.tpl" .}} {{template "footer-post.tpl" .}}