| From: | "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Explain analyze gives no info |
| Date: | 2005-06-21 12:50:34 |
| Message-ID: | 1806D1F73FCB7F439F2C842EE0627B180228F139@usa0300ms01.na.xerox.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am trying to optimize a delete query that's currently taking 4 hours
to run. My first step was to add some indexes on some of my FK's. That
sped up my select queries by as much as ~20x. From 3.5 sec to < 0.25
sec. They didn't help my delete query. I ran an explain analyze on the
delete query and the records got deleted after 4 hours but it never
showed me the query plan. I'm using 8.0.1 on WinXP accessing it with
pgAdminIII.
FWIW, the DB has a lot of FK's and some of them (the ones on my big
tables 1-10 million records) have ON DELETE CASCADE triggers.
Any suggestions for how to get the explain analyze output?
Mike
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Tesser | 2005-06-21 12:56:19 | Re: problems with types after update to 8.0 |
| Previous Message | FERREIRA, William (COFRAMI) | 2005-06-21 12:42:00 | compilation postgresql/solaris error |