ema_check_ingres_lrq
The ema_check_ingres_lrq plug-in checks for long running queries. It displays a report on long running queries, including information on blocked queries.
The plug-in has the following format:
ema_check_ingres_lrq --system ii_system_value [-d db_options] [-i intval] [-f finish_hour]
[-l limit_number] [-m mail_dist] [-r from_address] [--nohup]| --help |--version
--system ii_system_value
Specifies the value of your Ingres II_SYSTEM.
--nohup
Runs plug-in as detached script.
-d db_options
Shows information for a particular or all databases. Specify db_options as follows:
dbname
Checks the specified database.
ALL
Checks all databases.
-i intval
Specifies an interval in seconds (intval) between checks.
-f finish_hour
Specifies the time to finish checking, where finish_hour is a two-digit representation. For example: 01 = 1 o'clock a.m.; 00 = midnight.
-l limit_number
Specifies maximum number of queries to report.
-m mail_dist
Specifies to whom the report will be emailed, where mail_dist is quoted string of comma separated email addresses.
-r from_address
Specifies from where the report will be sent, where from_address is a singular email address.
--version
Displays version of the plug-in.
--help
Shows usage statement for the plug-in.
Example:
Check every 60 seconds until midnight and report the first 50 long running queries.
ema_check_ingres_lrq --system $II_SYSTEM -d demodb -i 60 -f 00 -l 50
Last modified date: 01/30/2023