Re: R: Number of SQL queries - Mailing list psycopg

From Thomas Güttler
Subject Re: R: Number of SQL queries
Date
Msg-id e9e12704-ada0-f046-631e-45d528a93516@thomas-guettler.de
Whole thread Raw
In response to R: Number of SQL queries  (Federico Di Gregorio <fog@dndg.it>)
List psycopg
thank you for your reply. I guess I will use this tool in the future:

https://github.com/jazzband/django-silk#requestresponse-bodies


Am 19.07.2018 um 12:05 schrieb Federico Di Gregorio:
> ---- Thomas Güttler ha scritto ----
> 
> 
>  > 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.
> 
> 
> 
> psycopg2 doee not know about HTTP requests and if you enable connection pooling the same database connection is used

> multiple times. So no, you cant use psycopg to count the number of queries per request. Only Django can do that.
> 
> 
> federico
> 
> 
> 

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


psycopg by date:

Previous
From: Federico Di Gregorio
Date:
Subject: R: Number of SQL queries
Next
From: Christian Ferrari
Date:
Subject: Integration of Psycopg with XTA