Does this perf output seem 'normal'?

From: Peter Devoy <peter(at)3xe(dot)co(dot)uk>
To: "Psql_General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Does this perf output seem 'normal'?
Date: 2016-04-26 23:27:31
Message-ID: CABoFc_jK6NAXZgPOaGw66bM4_qMSn0iFtSj628LV6E4ecRsRGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I am trying to work out why a piece of software, Mapnik, is executing
slowly. All it is doing is loading a config file which causes about
12 preparation queries (i.e. with LIMIT 0) to be executed. I can see
from pg_stat_statements these only take ~1ms in their totality.

So next I ran "perf record -a -g sleep 0.4" and quickly loaded my PHP
page to start the process (I am interfacing with mapnik via a PHP
Extension), this is a sample of the result:

https://cloud.githubusercontent.com/assets/4375326/14836015/08b0a8b4-0c05-11e6-96e5-f1836497cdfe.png

The PHP page returns in ~60ms (well within the 400ms used for the perf
recording). If possible, please can anyone with more familiarity with
perf and Postgres tell me whether the result of the recording looks
healthy?

I am wondering if there is some problem with the way in which Mapnik
is implementing libpq -- I already moved from Mapnik 2.2 because it
was effectively DOSing Postgres by leaving client connections open.

Any help would be greatly appreciated.

Kind regards

Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim van der Linden 2016-04-26 23:27:50 Slow join over three tables
Previous Message Cal Heldenbrand 2016-04-26 17:18:11 Re: psql color hostname prompt