Postgres Pro
Downloads
Home   >   mailing lists

How check execution plan of a function - Mailing list pgsql-performance

From Sabin Coanda
Subject How check execution plan of a function
Date
Msg-id hphv0u$18f$1@news.hub.org
Whole thread Raw
Responses Re: How check execution plan of a function
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: norn
Date:
Subject: significant slow down with various LIMIT
Next
From: Joel Jacobson
Date:
Subject: Re: LIMIT causes planner to do Index Scan using a less optimal index