Re: [PERFORM] help on slow query using postgres 8.4

2012-11-20 Thread Kevin Grittner
Maria L. Wilson wrote: > Can someone shed some light on the following query. > any help would certainly be appreciated! The query text and EXPLAIN ANALYZE output are a good start, but a lot of other information is needed to really understand the issue. http://wiki.postgresql.org/wiki/SlowQue

[PERFORM] help on slow query using postgres 8.4

2012-11-19 Thread Maria L. Wilson
Can someone shed some light on the following query. any help would certainly be appreciated! thanks - * Maria Wilson Nasa/Langley Research Center Hampton, Virginia m.l.wil...@nasa.gov * explain analyze select a.ID, a.provider, a.hostname, a.username, a.eventTimeStamp, a.AIPGUID, a.