Skip to main content

Comparison between count trends

Home > Select Project > Analysis > Counts Trend Comparison

You can check the operation trend of the key metrics of the database over time and trace the performance. You can also check the database operation trend by comparing the count trends on different dates. Through the Active sessions table, you can check active sessions and identify long-running sessions.

Basic screen guide

Counts Trend

  • If you select number 1 Base date, number 2 Comparison date, and Instance, the data is automatically applied to all widgets based on the selected items.

  • To see the meaning of the metric displayed in the widget, select Information icon next to the name or see the following.

    Note

    The tooltip of the Information Icon button is not supported in multiple languages.

  • To change the position with another widget, select and drag the upper part of the widget. However, the size of the widget cannot be changed.

  • The left of the number 3 Active sessions table displays the data for the Base date, and the right of the table displays the data for the Comparison date.

  • In the number 3 Active sessions table, the text colors are changed black → orangeRed, which means that the performance of the session is getting slower.

Selecting a comparison target

Select number 1 Base date and Instance, and then select number 2 Comparison date and Instance. If you hover your mouse over the chart, you can compare the data through the tooltip that appears.

  • The solid line in the graph chart displays the data for the Base date, and the dotted line displays the data for the Comparison date.

  • The items marked with (Comparison) in the tooltip are the data for the Comparison date.

Note
  • In Database, you can select a database for comparison.

  • The colors in Database are the same in the graph chart.

Comparing the active session data

Active Sessions

  • The time zone for data retrieval can be checked in number 4.

  • Active session data is collected every 5 seconds. You can search data for the desired time by selecting the button that moves in 5-second increments on the table.

  • If you select Previous time icon or Next time icon on the upper right, you can see the data in 1-minute increments. To move in increments of 5 seconds, select 5 seconds before icon or 5 seconds after icon.

  • In the Active sessions table list, the text colors are changed black → orangeRed, which means that the performance of the session is getting slower.

  • If you click a specific time point of the graph chart, the (number 3) area appears with a red line and the collected active sessions can be also seen.

Comparing with a specific time

Active sessions

You can compare the data by zooming in on a specific time point. Select a desired time zone to anywhere on the widgets and then drag the chart. It displays the data for a specific time zone dragged to all widgets and active session tables.

Preset

In Monitoring a Database Instance, you can load the custom widget settings and the sorted active sessions as presets.

Note

For more information about the Preset configuration, see the following.

Column information guide

ItemDescription
pidProcess ID
dbDatabase name
userSQL execution account
applicationClient application name
client_hostHost name of the connected client (reported by reverse DNS lookup of client_addr)
client_addrClient IP address
client_portClient port number (in case of using the UNIX socket -1)
query_hashHash value of query (internal WhaTap control value)
query_startTime when the active query started (if the state is not active, it is the last query started time)
stateCurrent status of the backend process (active, idle, etc.)
state_changeLast time when the state was changed
xact_startTime when the current transaction for the process started (null if no transaction is active)
backend_startTime when the backend process started
backend_xminMinimum value of xid whose backend process is being processed
backend_typeType of the backend process (e.g. autovacuum worker, logical replication launcher, client backend, checkpointer)
backend_xidxid whose backend is being processed
wait_event_typeType of the event whose backend process is in standby
wait_eventWaiting event name where the backend process is in standby
Note

WhaTap basically stores the client-related information.