Page /templates

Purpose — monitor queries in the context of a specific query.

To get to the page

To go to the “templates” page, go to the section “Problematic queries” on the /Plans page, select the pattern you are interested in:

Page Control Panel

Panel composition (as numbered in the figure above):

  1. pg_m_page_control_panel_burger-menu;

  2. Page Control Panel pg_monitor;

  3. Button for creating a link to a task;

  4. heatmap, displays the usage rate of queries with this pattern in a graph divided into 24 hours.</pg_m_glossary-heatmap>

Template tab

Assignment — displays a list of plans that match the selected pattern (queries that differ in numerical values, but do not differ in the structure of query plans).

Page content:

#. .. include:: pg_m_glossary/pg_m_108time.gls #. .. include:: pg_m_glossary/pg_m_165приложение.gls #. .. include:: pg_m_glossary/pg_m_084rows.gls #. .. include:: pg_m_glossary/pg_m_086RRbF.gls #. .. include:: pg_m_glossary/pg_m_014buf_mem.gls

Model tab

Purpose — contains a list of patterns for this plan (further generalization of the template).

Page content:

#. .. include:: pg_m_glossary/pg_m_177Шаблон_метод.gls #. .. include:: pg_m_glossary/pg_m_005app.gls #. .. include:: pg_m_glossary/pg_m_153кол-во.gls #. .. include:: pg_m_glossary/pg_m_101sum_мс.gls #. .. include:: pg_m_glossary/pg_m_011avg_мс.gls #. .. include:: pg_m_glossary/pg_m_014buf_mem.gls #. .. include:: pg_m_glossary/pg_m_013buf_dsk.gls #. .. include:: pg_m_glossary/pg_m_070percent.gls #. .. include:: pg_m_glossary/pg_m_052last.gls #. .. include:: pg_m_glossary/pg_m_114Timeline.gls

Methods tab

Assignment—Displays the methods used by the template.

Page content:

#. .. include:: pg_m_glossary/pg_m_156Метод.gls #. .. include:: pg_m_glossary/pg_m_060miscellaneous_task_link_button.gls #. .. include:: pg_m_glossary/pg_m_153кол-во.gls #. .. include:: pg_m_glossary/pg_m_101sum_мс.gls #. .. include:: pg_m_glossary/pg_m_011avg_мс.gls #. .. include:: pg_m_glossary/pg_m_014buf_mem.gls #. .. include:: pg_m_glossary/pg_m_013buf_dsk.gls #. .. include:: pg_m_glossary/pg_m_070percent.gls #. .. include:: pg_m_glossary/pg_m_052last.gls #. .. include:: pg_m_glossary/pg_m_114Timeline.gls

Heatmap tab

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