Debugging features needed

From: Boboc Cristi <bobocc(at)yahoo(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Cc: "pgsql-general-owner(at)lists(dot)postgresql(dot)org" <pgsql-general-owner(at)lists(dot)postgresql(dot)org>
Subject: Debugging features needed
Date: 2021-11-05 11:28:21
Message-ID: 1395901381.802146.1636111701121@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!
    I need a feature that would me allow to debug "live" the work of an application together with a PostgreSQL database.

I think that if I would be able to define a session variable that is visible in pg_stat_activity (or in other system view, table or function) I would be more than happy.
Well, I have described what I see as a partial solution to my problem, the problem being: how to track a specific set of actions at database level of a given application user in the context of session pooling (so the user activity can jump from one session to another of the same pool).
If I would be able to set a "value" to a custom variable, then the app would simply need to set the value at each session usage, but I definitely understand that other mechanisms might help solving the problem (but I do not know any of these).
I think that I can implement a logging mechanism at database level instead (and I have some ideas about how to do that), but logging search is not quite live debugging.
Any help would be highly appreciated, thank you kindly.
Best regards, Cristi Boboc

Best regards, Cristi Boboc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Jain 2021-11-05 11:41:40 Re: Debugging features needed
Previous Message Pavel Stehule 2021-11-05 05:42:21 Re: An self-contained example "expanded" C data type