Page / Templates

Purpose is to monitor queries against a specific query.

Page transition order

To go to the «templates» page, you should select the template of interest under pg_m_Problem_queries on the /Plans page:

Page control panel

The composition of the panel (according to the numbering in the figure above):

  1. Burger menu of the page control panel;

  2. Page address in pg_monitor;

  3. Button to create a link to a task;

  4. heatmap, displays the usage rate of queries with the given template into graphs split over 24 hours.

Template tab

Assignment - Displays a list of plans that match the selected template (queries that differ in numerical values but do not differ in query plan structure).

Appointment -

Page composition:

  1. "time"

    Time to register the request.

    When pressed, translates the query page from the <pg_m_Архив_запрос>` archive to :ref:`.

  2. ..collapse::»application»

    Clicking translates the «by applications» tab of the <pg_m_Планы_по_приложениям>` to the «Plans» page.

  3. "RRbF"

    Rows Removed by Filter

    Clicking on a heading sorts the tab by that column.

    Displays the statistical information that can be seen in the query execution plan. This value indicates the number of rows that have been deleted since the filter was applied in the scan or join table operation.

    When the DBMS executes a query, it applies filters to the data to select only those rows that meet the specified conditions. «Rows Removed by Filter» displays the number of rows that were filtered and deleted after these conditions were applied. This value can be useful to analyze query performance and optimize query execution.

    Note that «Rows Removed by Filter» does not indicate the total number of rows selected or returned as a result of the query. RRbF refers only to the number of rows that were deleted after the filter was applied.

    RRbF information can be useful in streamlining queries and improving database performance. It can help identify places where indexes or table structure can be improved to reduce the number of rows that do not meet query conditions and are removed by the filter.

  4. "buf.mem"

    Queries whose buffers according to this pattern were considered to be read from memory.

    Clicking on a title sorts the tab by template name.

    Hovering over the value will display the tultype with the volume value.

Model tab

Purpose - Provides a list of templates for this plan (further template communication).

Page composition:

  1. "Template/method"

    Contains the <pg_m_glossary-pg_monitor_шаблон> pattern“ and the query method.

    Clicking on a title sorts the tab by template name.

    Clicking on the template title translates to the page of the template.

  2. "app"

    App name.

    Clicking on a title sorts the tab by template name.

  3. "count"

    Quantity.

    Clicking on a title sorts the tab by template name.

  4. "sum.ms"

    Total request time in milliseconds.

    Clicking on a title sorts the tab by template name.

  5. "avg.ms"

    Average request time in milliseconds.

    Clicking on a title sorts the tab by template name.

  6. "buf.mem"

    Queries whose buffers according to this pattern were considered to be read from memory.

    Clicking on a title sorts the tab by template name.

    Hovering over the value will display the tultype with the volume value.

  7. "buf:dsk"

    Queries whose buffers according to this template were considered read from disk.

    Clicking on a title sorts the tab by template name.

    Hovering over the value will display the tultype with the volume value.

  8. %

    Ratio of disk reads to total (less is better).

  9. "last"

    The time of the last request.

    Clicking on a title sorts the tab by template name.

    Clicking on a value takes you to the request page from the archive.

  10. "Timeline"

    A graph showing the intensity of problem Queries, broken down into 24 hours.

Methods tab

Purpose - Displays the methods used by this template.

Page composition:

  1. "Method"

    Method used in plan to perform a specific operation

  2. "count"

    Quantity.

    Clicking on a title sorts the tab by template name.

  3. "sum.ms"

    Total request time in milliseconds.

    Clicking on a title sorts the tab by template name.

  4. "avg.ms"

    Average request time in milliseconds.

    Clicking on a title sorts the tab by template name.

  5. "buf.mem"

    Queries whose buffers according to this pattern were considered to be read from memory.

    Clicking on a title sorts the tab by template name.

    Hovering over the value will display the tultype with the volume value.

  6. "buf:dsk"

    Queries whose buffers according to this template were considered read from disk.

    Clicking on a title sorts the tab by template name.

    Hovering over the value will display the tultype with the volume value.

  7. %

    Ratio of disk reads to total (less is better).

  8. "last"

    The time of the last request.

    Clicking on a title sorts the tab by template name.

    Clicking on a value takes you to the request page from the archive.

  9. "Timeline"

    A graph showing the intensity of problem Queries, broken down into 24 hours.

«heatmap» tab

Purpose - Displays a graph of the registration intensity of this template.