Filtering processes from the "High Percentage of Queries Waiting" alarm in PostgreSQL (4373458)

Filtering processes from the "High Percentage of Queries Waiting" alarm in PostgreSQL

The High Percentage of Queries Waiting" alarm in PostgreSQL is currently calculated by analyzing all of the backends (processes) that are in a waiting condition and compares them to the number that are NULL.

In a database with little activity, a number of background processes will add weight to the total number of processes, causing the alarm to fire.

Is it possible to filter out some of the system processes such as these?

• LogicalLauncherMain
• AutoVacuumMain
• WalSenderMain
• BgWriterHibernate
• CheckpointerMain
• WalWriterMain

 

WORKAROUND

Disable the alarm when using databases that have little activity.

STATUS

Enhancement Request FGPOSTG-I-20 has been logged to add the capability to filter out certain processes from being counted by the High Percentage of Queries Waiting alarm. This will be reviewed by Product Management for consideration in a future release of the PostgreSQL cartridge.

FGPOSTG-I-20