Horton

Re: [HACKERS] Feature: output index name in explain ...

Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>

View thread
From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: Zeugswetter Andreas SARZ <Andreas.Zeugswetter@telecom.at>
Cc: "'pgsql-hackers@hub.org'" <pgsql-hackers@hub.org>
Date: 1998-03-25T08:52:04Z
Lists: pgsql-hackers 
Zeugswetter Andreas SARZ wrote:
> 
> Since I wanted to know it, I extended explain to output the used (only the
> first)
> index on IndexScan.
> An explain with this patch applied says:
> 
> template1=> explain select * from pg_class where oid=1;
> NOTICE:  QUERY PLAN:
> Index Scan using pg_class_oid_index on pg_class  (cost=2.03 size=1 width=74)

I like this. Any objections ?

Vadim