R: Number of SQL queries

Поиск
Список
Период
Сортировка
От Federico Di Gregorio
Тема R: Number of SQL queries
Дата
Msg-id f6k462i4p2ed84f9kgdqg13u.1531994153088@email.android.com
обсуждение исходный текст
Ответ на Number of SQL queries  (Thomas Güttler <guettliml@thomas-guettler.de>)
Ответы Re: R: Number of SQL queries  (Thomas Güttler <guettliml@thomas-guettler.de>)
Список psycopg

---- 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

В списке psycopg по дате отправления:

Предыдущее
От: Thomas Güttler
Дата:
Сообщение: Number of SQL queries
Следующее
От: Thomas Güttler
Дата:
Сообщение: Re: R: Number of SQL queries