Proposal "stack trace" like debugging option in PostgreSQL

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Proposal "stack trace" like debugging option in PostgreSQL
Date: 2016-07-30 17:52:39
Message-ID: BLU437-SMTP58D2A967A6074E4FD1A21CF020@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear community,

Sorry if this is not the right place for proposing new features. Also,
sorry if I'm proposing something already existing.

I do currently use the "debug" extension to better understand the
entrophy of my application regarding database.

But in production this is not possible, and I would to propose a feature
that has less impact over production then a debug extension: a
stacktrace of calls.

Simular to Java stack traces, but disabled by default. When enabled, In
case of an event like "duplicate key" (or a function raise exception) or
other similar problems that wont allow the database to execute the SQL
command,the strack trace will bring the complete list of function call.

This would help to track down problems that escaped the development and
test environments, and reached the production systems.

If this feature already exists, please kindly point me to the docs. If
not, please consider adding this in a future release.

Thanks,

--
Atenciosamente,

Edson Carlos Ericksson Richter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2016-07-30 21:18:09 Re: restore a specific schema from physical backup
Previous Message Branden Visser 2016-07-30 15:21:54 Query planner using hash join when merge join seems orders of magnitude faster