Avoir seulement les requêtes utilisateur dans le log

jeudi 11 décembre 2014

Bonjour,




Je souhaite logger uniquement les requêtes envoyées par l'application cliente à la base.

Je constate que mon fichier de log comporte de nombreuses requêtes qui ne sont pas envoyées par le client.




Exemple, ici, seule la 1ère ligne correspond à une requête envoyée par le client :






2014-12-11 18:46:16 CET LOG: instruction : select * from "T_ASS_SINISTRE_SIN";
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,24) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,14) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,24) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 1082
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 1083
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 1082
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 1082
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,84) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,84) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 25
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 25
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 21
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 16
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 1082
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 25
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 25
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 16
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 16
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,7) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 16
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 1082
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 21
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 16
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 21
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 1082
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 1082
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 700
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 1700
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 16
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 16
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,54) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,14) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 23
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 25
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,54) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,14) as typname FROM pg_type WHERE oid = 1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 25
2014-12-11 18:46:17 CET LOG: instruction : SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 16
2014-12-11 18:46:17 CET LOG: instruction : SELECT CASE WHEN typbasetype=0 THEN oid else typbasetype END AS basetype
FROM pg_type WHERE oid=23
2014-12-11 18:46:17 CET LOG: instruction : SELECT CASE WHEN typbasetype=0 THEN oid else typbasetype END AS basetype
FROM pg_type WHERE oid=23
2014-12-11 18:46:17 CET LOG: instruction : SELECT CASE WHEN typbasetype=0 THEN oid else typbasetype END AS basetype
FROM pg_type WHERE oid=1043
2014-12-11 18:46:17 CET LOG: instruction : SELECT CASE WHEN typbasetype=0 THEN oid else typbasetype END AS basetype
FROM pg_type WHERE oid=1043




Vous conviendrez que cela fait beaucoup de lignes pour un simple select...




Mon serveur est en 9.4beta2 64 bits sur Windows 8.




Les paramètres que j'ai activé dans pgconf sont :






log_destination = 'stderr'
logging_collector = on
log_statement = 'all'
log_min_messages = 'log'
client_min_messages = 'error'




J'ai essayé plusieurs niveaux pour log_min_messages mais en vain.


Auriez vous une piste ?


Arnaud.





0 commentaires:

Enregistrer un commentaire

 

Lorem

Ipsum

Dolor