Yes it does: SET EXPLAIN ON; It writes the file to sqexplain.out -----Original Message----- From: pgsql-performance-owner@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane Sent: Tuesday, January 09, 2007 9:13 AM To: Gregory S. Williamson Cc: db@xxxxxxxxxxxx; pgsql-performance@xxxxxxxxxxxxxx Subject: Re: [PERFORM] Horribly slow query/ sequential scan "Gregory S. Williamson" <gsw@xxxxxxxxxxxxxxxx> writes: > HAving burdened others with my foolishness too often, I hesitate to > ask, but could someone either point me to a reference or explain what > the difference might be ... I can see it with the eyes but I am having > trouble understanding what Informix might have been doing to my (bad > ?) SQL to "fix" the query. Me too. Does informix have anything EXPLAIN-like to show what it's doing? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
