Limiting the amount of data in a variable when logging slow queries

From: Brett Delle Grazie <brett(dot)dellegrazie(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Limiting the amount of data in a variable when logging slow queries
Date: 2017-04-21 11:13:26
Message-ID: CACLD0=4i0ok16tfeCGsPujTM+nrQ-DGq+efPVKiWF6LjprwWAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We've enabled the slow query log and have a particular query that is
executing an insert against a table containing a binary array column.

Given the content being stored is upwards of 100MB+ this leads to very long
log messages for the slow query log.

Is there a way of having the slow query log only output the first 'n' bytes
of a byte array and/or exempting this particular insert?

Thanks,

--
Kind regards,

Brett Delle Grazie

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Neuner 2017-04-21 13:03:02 Re: full text search on hstore or json with materialized view?
Previous Message Akshay Joshi 2017-04-21 06:55:43 Re: [GENERAL] pgAdmin4 needs information of v10 SCRAM authentication