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

2018-11-02 Thread legrand legrand
Tomas Vondra-4 wrote > On 11/02/2018 10:36 AM, Richard Lee wrote: > [...] > >> What are my other options to improve the query planning time? >> > > Can you do a bit of profiling, to determine which part of the query > planning process is slow here? > [...] After planning profiling, (or in //),

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

2018-11-02 Thread Tomas Vondra
On 11/02/2018 10:36 AM, Richard Lee wrote: > Hi, > > I'm running a performance test for our application and encountered a > particular query with high planning time compared to the execution. > Please refer to attached explain.out for the explain analyze output. > > Formatted explain: https://exp