Terms and definitions in the context of log analysis

deadlock

Deadlock is a situation in a multitasking environment or DBMS when several processes are in the state of waiting for resources occupied by each other and none of them can continue their execution. It is a fatal error.

heatmap

A heatmap is a graphical view of data where individual values in a table are displayed using colour.

instance

lc_messages

Collation of messages.

log_line_prefix

Key for correct log parsing. Specified in the log_line_prefix variable from the database log source server.

params

catching queries that have exceeded parameters in their composition.

pg_stat_user_tables

View. Contains one row for each table in the current database (including TOAST tables) with statistics on accesses to that table. Provides pg_stat_all_tables information filtered to show only user and system tables respectively.

pid

Process id.

pidstat

The pidstat utility, short for PID Statistics, is used to monitor database processes in real time. This tool produces a variety of statistics about the process, including CPU usage, the process’s use of disc namespace, and threads associated with selected tasks and child processes.

PSA_apps

PSA_heatmap

resultset

total output traffic volume

VACUUM

namespace

megaqueries

Queries exceeding 1MB of incoming or outgoing traffic.

Query Plan Summary: A query plan pattern where nodes are aggregated to specific table operations

Host

an instance deployed on PostgreSQL.

Node

Plan Node.

Sphinx Sphinx is a to