Skip site navigation (1) Skip section navigation (2)

Re: Pet Peeves?

From: wstrzalka <wstrzalka(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-02-02 22:01:51
Message-ID: d9d742d9-831d-4d9e-b0f8-f7ce9cc72be3@v39g2000pro.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-general
> - EXPLAIN does not work with functions.
+1

and one more about explain - it would be great to have smth like:
EXPLAIN ANALYZE FULL - that would show details about the plan chosen
with detailed explanation and other plans considered.

It would reduce a few posts a week in style:
- 'why the query A doesn't use index B'
with answer
- '... planner .... estimated cost ....'

I think it would help a lot of people if the community don't want to
have hints.


In response to

pgsql-general by date

Next:From: David FetterDate: 2009-02-02 22:08:26
Subject: Re: Is dropping pg_ts_* harmful?
Previous:From: Martijn van OosterhoutDate: 2009-02-02 22:00:08
Subject: Re: plpgsql and control structures

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group