[PERFORM] slow query on postgres 8.4

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.

FW: [PERFORM] slow query on postgres 8.4

> explain analyze > select a.ID, a.provider, a.hostname, a.username, a.eventTimeStamp, > a.AIPGUID, a.submissionGUID, a.parentSubmissionGUID, a.sizeArchived, > a.addedContentString, a.addedContentSizesString, a.removedContentString, > a.removedContentSizesString, a.modifiedContentStr