Hi all,
I have this simple query that has performance issue. I am assuming there is something wrong in our configuration. Can someone point me to the right direction? (our work_mem is set to 64MB)
srdb=> explain analyze 013-04-15 16:51:20,223 INFO [com.vasoftware.sf.server.common.querygenerator.Query] (http--127.0.0.1-8080-11) Query: [Id: 4652] [duration: 51999][debug sql] SELECT
psrdb(> MAX(length(discussion_post.id)) AS maxLength
psrdb(> FROM
psrdb(> discussion_post discussion_post^C
psrdb=> explain analyze SELECT
psrdb-> MAX(length(discussion_post.id)) AS maxLength
psrdb-> FROM
psrdb-> discussion_post discussion_post
psrdb-> ;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=10000043105.13..10000043105.14 rows=1 width=10) (actual time=52150.015..52150.015 rows=1 loops=1)
-> Seq Scan on discussion_post (cost=10000000000.00..10000041980.90 rows=449690 width=10) (actual time=0.006..51981.746 rows=449604 loops=1)
Total runtime: 52150.073 ms
(3 rows)
Thanks a lot,
Anne