Django + postgresql: log how long a query took to execute?

Question

Beginner question, and it's probably a duplicate, sorry! But I can't find the answer by Googling or by searching on here.

My Django/postgres application is slow. I know how to log the queries being executed on postgres, so I'm doing that.

Now, how do I identify which of them are slow... short of typing them all in myself, and using a stopwatch?

In short: is there a way to log how long each query took to execute, using Django ORM & a postgres database?

score 1 · Accepted Answer · answered Jun 13 '13 at 11:42

1

You need django-debug-toolbar. Thanks me later.

Or if you want to do it manually then:

import time

start = time.time()
# execute your query here
stop = time.time() - start
print stop # or log this time

answered Jun 13 '13 at 11:42

Aamir Rind

score 1 · Answer 2 · answered Jun 13 '13 at 11:51

1

log all slow queries

set log_min_duration_statement = 200ms in postgresql.conf file

answered Jun 13 '13 at 11:51

Pavel Stehule

score 0 · Answer 3 · answered Jun 13 '13 at 12:25

0

I have used pgFouine to analyse my postgres logs - see http://pgfouine.projects.pgfoundry.org/tutorial.html for how to set up logging and how to analyse them with pgFouine.

answered Jun 13 '13 at 12:25

Paul Tomblin

3 Answers3