Search Postgresql Archives

Re: Postgres csv logging

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



It is customary to indicate when you've posted the same question to other forums - in this case SO.


As the comment there says your config and your output seem at odds.  Though I think your confusion is still adequately represented.

On Wed, Jul 19, 2017 at 4:41 PM, Alessandro_feliz <Alessandro_feliz@xxxxxxxxxxx> wrote:
Why is the first line, that has the query executed, saying that the command
tag is "idle", shouldn't it say "SELECT"?

"Command tag: type of session's current command" - given your example I suppose this means "initial state of the session" as opposed to being a category tag of what the current line is doing.  What you are seeing is "start at idle and parse" the incoming statement text.  That is one action - parse.  The subsequent action is "execute" the contents of the SELECT that is now in the active state of the session.

If the above is correct the docs could be more clear since I'd agree that your interpretation of the field seems more logical - though knowing initial state is quite useful in its own right.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux