Hi everyone,
I am currently undertaking measures to improve performance of an
application that we use very frequently. I am using Django-0.96 and
PostgreSQL 8.1 database. In order to see exactly what is happening on
a database level, I have been examining my PostgreSQL logs and found
the following query is executed numerous times in succession:
2008-02-04 10:48:13 GMT LOG: statement: ABORT
2008-02-04 10:48:13 GMT LOG: statement: SET DATESTYLE TO 'ISO'
2008-02-04 10:48:13 GMT LOG: statement: BEGIN; SET TRANSACTION
ISOLATION LEVEL READ COMMITTED
2008-02-04 10:48:13 GMT LOG: statement: SET TIME ZONE 'Europe/London'
2008-02-04 10:48:13 GMT LOG: statement: SELECT
"django_session"."session_key","django_session"."session_data","django_session"."expire_date"
FROM "django_session" WHERE ("django_session"."session_key" =
'563f524d380893342c5f089acce805f3' AND "django_session"."expire_date"
> '2008-02-04 10:48:13.237439')
2008-02-04 10:48:13 GMT LOG: statement: ABORT
2008-02-04 10:48:13 GMT LOG: statement: SET DATESTYLE TO 'ISO'
2008-02-04 10:48:13 GMT LOG: statement: BEGIN; SET TRANSACTION
ISOLATION LEVEL READ COMMITTED
2008-02-04 10:48:13 GMT LOG: statement: SET TIME ZONE 'Europe/London'
2008-02-04 10:48:13 GMT LOG: statement: SELECT
"django_session"."session_key","django_session"."session_data","django_session"."expire_date"
FROM "django_session" WHERE ("django_session"."session_key" =
'563f524d380893342c5f089acce805f3' AND "django_session"."expire_date"
> '2008-02-04 10:48:13.247914')
I was hoping someone could shed light on what might be causing it this
query? It happens about 20 times in a row.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
