Postgres Pro
Downloads
Home   >   mailing lists

Number of SQL queries - Mailing list psycopg

From Thomas Güttler
Subject Number of SQL queries
Date
Msg-id 2b82b783-e2f2-2fff-e2c6-120b7325828e@thomas-guettler.de
Whole thread Raw
Responses R: Number of SQL queries  (Federico Di Gregorio <fog@dndg.it>)
List psycopg
Tree view 
I would like to know the number of sql queries which were executed during a http request.

Is there a way to get this number?

I would like to warn if a http request produces too many statements.

I am running a django application. If DEBUG is True, then django writes all queries into a list (connection.queries). 
But I would like to get this value from a production server. On the production server DEBUG is False and
connection.queries does not get filled by django.

It would be nice to get this value from psycopg2.

Regards,
   Thomas



-- 
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines

psycopg by date:

Previous
From: Sandeep Thakkar
Date:
Subject: psycopg2 2.7.5 linking error
Next
From: Federico Di Gregorio
Date:
Subject: R: Number of SQL queries