| From: | "Iwata, Aya" <iwata(dot)aya(at)jp(dot)fujitsu(dot)com> |
|---|---|
| To: | 'Jacob Champion' <pchampion(at)pivotal(dot)io>, 'Jim Doty' <jdoty(at)pivotal(dot)io> |
| Cc: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, "nagata(at)sraoss(dot)co(dot)jp" <nagata(at)sraoss(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 'Haribabu Kommi' <kommi(dot)haribabu(at)gmail(dot)com>, 'Peter Eisentraut' <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Subject: | RE: libpq debug log |
| Date: | 2019-01-18 08:18:35 |
| Message-ID: | 71E660EB361DF14299875B198D4CE5423DEB9E4B@g01jpexmbkw25 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I have developed a new libpq trace logging aimed at checking which side (server or client) is causing the performance issue.
The new libpq trace log can do the following things;
- Setting whether to get log or not by using connection strings or environment variables. It means that application source code changes is not needed to get the log.
- Getting time when receive and send process start/end. Functions too.
- Setting log level; When level1(default) is set, it outputs the time in the function and connection time. When level2 is set, it outputs information on the protocol message being exchanged, in addition to level1 information.
I updated patch, but I am not sure if these changes and implementation are correct or not. So I need your comment and advice.
I would appreciate your advice and develop/fix my patch further.
Regards,
Aya Iwata
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2019-01-18 08:26:49 | Re: PSA: we lack TAP test coverage on NetBSD and OpenBSD |
| Previous Message | Peter Eisentraut | 2019-01-18 08:03:18 | Re: Log a sample of transactions |