Jump to content
Fórum Script Brasil
  • 0

Estatísticas De Query


Guest --Claudia --
 Share

Question

Guest --Claudia --

Eu preciso saber se tem como pegar todas as Querys que são submetidas ao PostgreSQL e suas frequencias de submissão.

Tem algum lugar do SGBD PostgreSQL onde é guardadas as Querys que são processadas por ele?

Ou será que tem algum lugar que de para configurar para ser gravado em arquivo por exemplo as query que o SGBD processa?

Preciso saber disso urgente para meu trabalho.

Obrigada

Claudia

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

verificando o manual dos comandos psql:

Query Buffer

\e [FILE]edit the query buffer (or file) with external editor

\g [FILE] send query buffer to server (and results to file or |pipe)

\p show the contents of the query buffer

\r reset (clear) the query buffer

\s [FILE] display history or save it to file

\w FILE write query buffer to file

Ve se isso ajuda.

;)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



  • Forum Statistics

    • Total Topics
      150.1k
    • Total Posts
      647k
×
×
  • Create New...