Re: parse - bind take more time than execute

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



thx a lot for your answer :)

2) default_statistics_target is set to (default) 100 and there no special
statistics per-column

3) i will do that very soon

4) in absolute units i can see the same query having similar stats to these:
parse -> 600 ms
bind -> 300 ms
execute -> 50 ms

the query mentioned above is a simple select from one table using using two
where conditions. and this table has 1 additional index (except the primary
key) on the columns that are part of the where clause

--
View this message in context: http://postgresql.1045698.n5.nabble.com/parse-bind-take-more-time-than-execute-tp5102940p5103116.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux