Re: Can i see server SQL commands ? - Mailing list pgsql-general

From Adnan DURSUN
Subject Re: Can i see server SQL commands ?
Date
Msg-id BAY106-DAV58E76BEB6EA5DE5A035D7FA180@phx.gbl
Whole thread Raw
In response to Can i see server SQL commands ?  ("Adnan DURSUN" <a_dursun@hotmail.com>)
Responses Re: Can i see server SQL commands ?  (Shane Ambler <pgsql@007Marketing.com>)
List pgsql-general
----- Original Message -----
From: "Jim C. Nasby" <jim@nasby.net>

> Didn't someone just ask this yesterday?

    Yes. i did it :-)

> I believe you can get that info by increasing client_min_messages.
> What you specifically have to set it to I don't know; my guess would be
> log or debug1.

    I set it that but none of them effect the result :-( I think, answer to
this question is no !
Things that i want to see is what SQL commands run by backend while ;

    * Inserting a row (how checks FKs)
    * Updating row (how checks FKs and unique constrains)
    * deleting row (how checks FKs)

Best Regards
Adnan DURSUN




pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Expected accuracy of planner statistics
Next
From: Tom Lane
Date:
Subject: Re: Row versions and indexes