Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time

From:	"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:	"Achilleas Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject:	Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
Date:	2011-01-14 14:41:18
Message-ID:	4D300C2E0200002500039569@gw.wicourts.gov
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2011-01-11 15:53:22 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>  2011-01-11 16:19:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2011-01-12 11:18:43 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>    2011-01-12 15:07:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2011-01-12 16:17:10 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> 📎      2011-01-12 16:45:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2011-01-12 17:17:28 from "Mark Felder" <feld(at)feld(dot)me>        2011-01-13 10:35:12 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>       2011-01-13 12:13:21 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>        2011-01-13 12:27:26 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>       2011-01-13 14:13:23 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>        2011-01-14 13:53:38 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>         2011-01-14 14:41:18 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>          2011-01-14 15:26:50 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>          2011-01-14 15:49:31 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>          2011-01-14 15:52:34 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>           2011-01-14 20:06:56 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>            2011-01-14 20:32:15 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>            2011-01-14 20:59:28 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>             2011-01-14 21:20:25 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>              2011-01-14 22:18:51 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>               2011-01-14 22:35:44 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>                2011-01-17 15:39:30 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>      2011-01-12 19:17:00 from Alex Hunsaker <badalex(at)gmail(dot)com>       2011-01-13 10:17:52 from Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Lists:	pgsql-admin

In response to

• Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time at 2011-01-14 13:53:38 from Achilleas Mantzios

Responses

• Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time at 2011-01-14 15:26:50 from Achilleas Mantzios
• Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time at 2011-01-14 15:49:31 from Achilleas Mantzios
• Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time at 2011-01-14 15:52:34 from Achilleas Mantzios

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Achilleas Mantzios	2011-01-14 15:26:50	Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
Previous Message	Vladimir Rusinov	2011-01-14 14:09:28	Re: rpm failure