Debug PostgreSQL sql query

Question

Is there a way to configure PostgreSQL so that when I run a "delete from table_a;" it outputs some information how many entries that was cascade deleted.

I'm running my querys in the cli application.

heldt · Accepted Answer · 2011-11-18 13:51:29Z

9

I found a solution. It was good enough for me, though I wanted a estimated statistics on how many rows that were effected.

This will ouput a list of all constraints triggered by the query.

EXPLAIN ANALYZE DELETE FROM table_a;

answered Nov 18, 2011 at 13:51

heldt

4,30610 gold badges41 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Silas Parker · Accepted Answer · 2011-11-18 13:55:49Z

0

You could use a plpgsql trigger function on tables to increment a sequence on a delete to get an exact count.

You would need to reset the sequence before issuing the delete. You could use a different sequence per table to get per table statistics.

answered Nov 18, 2011 at 13:55

Silas Parker

8,1771 gold badge32 silver badges44 bronze badges

Collectives™ on Stack Overflow

Debug PostgreSQL sql query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related