Le 2 juillet 2017 10:39:09 GMT+02:00, Tomas Vondra
a écrit :
>
>
>On 07/02/2017 03:26 AM, Daviramos Roussenq Fortunato wrote:
>> I am using pgAdmin for SQL test.
>>
>> Linux:
>>
>> EXPLAIN ANALYZE select * from
>> "Seq Scan on lancamentosteste (cost=0.00..49289.74 rows=1883774
>> width=92) (a
Le 15/02/2013 19:04, Jeff Janes a écrit :
On Fri, Feb 15, 2013 at 1:00 AM, Nicolas Charles
wrote:
On 14/02/2013 20:27, Jeff Janes wrote:
I'm surprised that the executiontimestamp index is not used, since it
seems
to be where most of the query time is spent.
I do not draw that conclusion
On 14/02/2013 20:27, Jeff Janes wrote:
On Thu, Feb 14, 2013 at 7:35 AM, Nicolas Charles
wrote:
It contains 11018592 entries, with the followinf patterns :
108492 distinct executiontimestamp
14 distinct nodeid
59 distinct directiveid
26 distinct ruleid
35 distinct serial
How many entries fall
Hello,
I've been struggling to understand what's happening on my
databases/query for several days, and I'm turning to higher mind for a
logical answer.
I'm dealing with a fairly large database, containing logs informations,
that I crunch to get data out of it, with several indexes on them th
