Savita <savita@india.hp.com> writes:
> When I type the command
> CYCLE4#EXPLAIN ANALYZE
> CYCLE4# select * from os_customer_master where OUTSOURCER_LEGACY_CUSTOMER_ID='66';
> why I get the error
> ERROR: parser: parse error at or near "ANALYZE"
In that case you must be running PG 7.1 or older. EXPLAIN's ANALYZE
option is new in 7.2.
This will also mean you need to say "VACUUM ANALYZE" to update the
planner statistics, not just "ANALYZE" as I suggested in my previous
message.
On the whole I'd recommend updating to PG 7.2.3 instead.
regards, tom lane