Home > mailing lists

Run one query and execution time is very different - Mailing list pgsql-performance

From	Metatrader EA
Subject	Run one query and execution time is very different
Date	November 16, 2016 09:10:42
Msg-id	CAJNXAk39CqDNv2GQA=Jb6=gDb4-EDoom_z754T9PCaS1N=xLmA@mail.gmail.com Whole thread Raw
List	pgsql-performance

Tree view

Hi,

I run one query and the execution is very different

Select messages
   from   mails_hist
   join   mails using (messages)
   where message_date > '2016-07-19 00:00:00'
   and    message_date < '2016-10-17 00:00:00'
   Group by message;

message_date is one timestamp

Query gives around 6300 rows

What can I look for ?

//Bill

pgsql-performance by date:

From: Gabriela Serventi
Date: 16 November 2016, 00:50:57
Subject: Re: Performance decrease after upgrade to 9.6.1

From: Metatrader EA
Date: 17 November 2016, 10:43:27
Subject: Query hangs sometimes

Run one query and execution time is very different - Mailing list pgsql-performance

Previous

Next