Hi pgsql-performance,
I've a problem with the select * on a small table.
See below:
x7=# EXPLAIN ANALYZE select * from megjelenesek;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------
Seq Scan on megjelenesek (cost=0.00..15633.07 rows=207 width=52)
(actual time=103.258..18802.530 rows=162 loops=1)
Total runtime: 18815.362 ms
(2 rows)
x7=# \d megjelenesek;
Table "public.megjelenesek"
Column | Type |
Modifiers
-------------+-----------------------------+------------------------------------------------------------
idn | integer | not null default
nextval('megjelenesek_idn_seq'::regclass)
tag_id | integer |
tag_wlap_id | integer |
get_date | timestamp without time zone | default now()
megjelent | numeric | default 0
Indexes:
"megjelenesek_pkey" PRIMARY KEY, btree (idn)
"megjelenesek_tag_id" hash (tag_id)
"megjelenesek_tag_wlap_id" hash (tag_wlap_id)
x7=# SELECT count(idn) from megjelenesek;
count
-------
162
(1 row)
Why does it take cca 18-20 sec to get the results?
Too many indexes?
--
Adam PAPAI
D i g i t a l Influence
http://www.wooh.hu
E-mail: wooh@xxxxxxx
Phone: +36 30 33-55-735 (Hungary)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
