query-plan-1189
Change label- Query Plan as raw text
-
- Summary
-
Limit (cost=1768052.54..1768053.47 rows=373 width=297) -> Sort (cost=1768052.54..1768053.47 rows=373 width=297) Sort Key: postenddate -> Seq Scan on nb_temp_files (cost=0.00..1768036.60 rows=373 width=297) Filter: ((procstat IS NOT NULL) AND (NOT moved) AND (procdate < 1226057115) AND (msgcount = msgfound) AND (moveafter = 0))

[EXPLAIN ANALYZE].EXPLAINand interpreting its output, see the Postgres documentation, in particular theEXPLAINandANALYZEreferences pages, and Using Explain.