Re: Fwd: Query with high planning time compared to execution time

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Richard Lee <swift1984(at)gmail(dot)com>
Cc: tomas(dot)vondra(at)2ndquadrant(dot)com, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Fwd: Query with high planning time compared to execution time
Date: 2018-11-05 13:55:19
Message-ID: 20181105135519.GA25283@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Nov 05, 2018 at 03:04:29PM +0800, Richard Lee wrote:
> Executed perf-record and perf-report:
> -bash-4.2$ perf record -g -- psql -U sri sri <
> /var/lib/pgsql/10/data/pg_log/1-b10/query.txt
> < ... snipped ... >

That's showing perf output for the psql client. What you want is output for
the server process (essentially all the client does is move data between the
user to the server).

https://wiki.postgresql.org/wiki/Profiling_with_perf

Justin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Lee 2018-11-06 11:40:50 Re: Fwd: Query with high planning time compared to execution time
Previous Message Richard Lee 2018-11-05 07:04:29 Re: Fwd: Query with high planning time compared to execution time