From: Sabin Coanda <sabin.coandaSPAMPROTECTION@deuromedia.ro>
To: pgsql-performance@postgresql.org
Subject: How check execution plan of a function
Date: Wed, 7 Apr 2010 15:47:54 +0300
Message-ID: <hphv0u$18f$1@news.hub.org> (raw)
Hi there,
I have a function which returns setof record based on a specific query.
I try to check the execution plan of that query, so I write EXPLAIN ANALYZE
before my select, I call the function and I see the result which shows an
actual time about 5 seconds. But when I call my function after I remove
EXPLAIN ANALYZE it takes more than 300 seconds, and I cancel it.
What's happen, or how can I see the function execution plan to optimize it ?
TIA,
Sabin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sabin.coandaSPAMPROTECTION@deuromedia.ro
Subject: Re: How check execution plan of a function
In-Reply-To: <hphv0u$18f$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox