I am using Postgres as my Database. I need to know whether I can extract all the queries that got executed with out logging them as logging all the queries will degrade the performance of database. So, provide a way I can get all the queries that got executed with out logging the queries.
PostgreSQL – Logging All Queries
logpostgresql
Related Question
- Using the Correct PostgreSQL Server
- PostgreSQL – Query History Hacking Techniques
- PostgreSQL – Viewing Disk Usage of Temporary Buffers
- Postgresql – How to get postgres to log the stored procedures it is running
- Mariadb – Logging remote transactions in mariadb
- PostgreSQL – How to Ensure pg_stat_activity Shows All Queries
- Postgresql – Retrieving the value of $1, $2 etc. from a Postgres Query
Best Answer
If not logging the queries, there is no chance. However, if you are looking for some statistics to find e.g. queries which are executed very often and therefore an optimization could make sense: Checkout pg_stat_statment-extension