On 10/15/05 10:00 AM, "NSO" <[EMAIL PROTECTED]> wrote: > Hello, > > How about some explain analyze output? > Explain analyse select * from files where nr > 1450 > > "Index Scan using pk on files (cost=0.00..3.67 rows=50 width=36) > (actual time=0.000..0.000 rows=50 loops=1)"
I may not be understanding the output, but your actual time reports 0 for the query. And the total runtime is 23 seconds? Sean >> On 10/15/05 9:20 AM, "NSO" <[EMAIL PROTECTED]> wrote: >> >>> Hello, >>> >>> I am trying to select form table with bytea field. And queries runs very >>> slow. >>> My table: >>> CREATE TABLE files (file bytea, nr serial NOT NULL) WITH OIDS; >>> >>> Query: >>> select * from files where nr > 1450 >>> >>> (I have total 1500 records in it, every holds picture of 23kB size) >>> Query runs very long: >>> Total query runtime: 23625 ms. >>> Data retrieval runtime: 266 ms. >>> 50 rows retrieved. >>> >>> explain: >>> Index Scan using pk on files (cost=0.00..3.67 rows=50 width=36) >>> Index Cond: (nr > 1450) >>> >>> Is it possible to do something with it? or it is normal? Our server is >>> fast, and all other tables work fine.. >> >> How about some explain analyze output? Have you done a full vacuum >> lately? >> How about reindexing? >> >> Sean >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: explain analyze is your friend >> >> -- >> This message has been scanned for viruses and >> dangerous content, and is believed to be clean. >> >> > > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
