[TNM] EXCLUDE filter not working for temptable?

David dbwagoner at gmail.com
Thu Oct 30 12:52:54 UTC 2014


I want to use tail_n_mail to monitor for temp tables.  I am trying to
filter out temp tables created by my vacuum cron job, as shown in the log
example excerpt below:

2014-10-30 01:02:01 EDT [30494]: [1-1] user=postgres,db=MyDB LOG:
 statement: CREATE TEMP TABLE vacuum_l AS SELECT oid AS lo FROM
pg_largeobject_metadata


I've tried these two versions of the EXCLUDE statement in
my tnm.config.tempfile.txt file:

EXCLUDE: CREATE TEMP TABLE vacuum_l

EXCLUDE: "CREATE TEMP TABLE vacuum_l"


I still get email like the following:

Date: Thu Oct 30 06:15:02 2014 EDT

Host: myserver

Matches from
/postgres/data/9.2AS/data/pg_log/postgresql-2014-10-30_000000.log: 2

   Top items by arithmetic mean    |   Top items by total size

----------------------------------+-------------------------------


*Questions*:

  1.  Why is my EXCLUDE not working?

2.  Why is the output table empty?

Thanks for your help!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/tnm/attachments/20141030/bcfacfb2/attachment.html>


More information about the TNM mailing list