Re: [HACKERS] Feature: output index name in explain ... - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] Feature: output index name in explain ...
Date
Msg-id 3518C5B4.6DA56790@sable.krasnoyarsk.su
Whole thread Raw
In response to Feature: output index name in explain ...  (Zeugswetter Andreas SARZ <Andreas.Zeugswetter@telecom.at>)
Responses Re: [HACKERS] Feature: output index name in explain ...
List 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

pgsql-hackers by date:

Previous
From: Zeugswetter Andreas
Date:
Subject: Re: [HACKERS] Re: PostgreSQL reference manual (groups)
Next
From: Zeugswetter Andreas
Date:
Subject: Re: [HACKERS] char types gone.