Help with performance and explain.
От | Oisin Glynn |
---|---|
Тема | Help with performance and explain. |
Дата | |
Msg-id | 44AEB375.9070804@oisinglynn.com обсуждение исходный текст |
Ответы |
Re: Help with performance and explain.
|
Список | pgsql-sql |
I have an issue with a select returning very slowly approx 198 seconds. I took a backup of this DB and restored it on another system and it is returning in 28 seconds. Windows 2000 PG Version 8.0.3 Data is inserted into the table row by row. Table has index on service explain SELECT callrecord."service", callrecord."timequeuing", callrecord."timeconversation", callrecord."timeoffering", callrecord."calltype", callrecord."application" FROM "public"."callrecord" callrecord ORDER BY callrecord."service" ASC "Sort (cost=284032.83..284322.17 rows=115734 width=46)" " Sort Key: service" " -> Seq Scan on callrecord (cost=0.00..270144.34 rows=115734 width=46)" Windows 2000 Version 8.0.1 DB created from backup of other server. explain SELECT callrecord."service", callrecord."timequeuing", callrecord."timeconversation", callrecord."timeoffering", callrecord."calltype", callrecord."application" FROM "public"."callrecord" callrecord ORDER BY callrecord."service" ASC "Sort (cost=17465.33..17754.65 rows=115729 width=46)" " Sort Key: service" " -> Seq Scan on callrecord (cost=0.00..3577.29 rows=115729 width=46)" Any help would be greatly appreciated. Oisin
В списке pgsql-sql по дате отправления: