Re: PostgreSQL performance

Yes. Look at the pg_statio% views in system catalog.

2010/8/30, Valoo, Julian <Julian(dot)Valoo(at)fnb(dot)co(dot)za>:
> Hi
>
>
>
> Are there any performance tuning tools for PostgreSQL, besides explain.
> Any system management views to find out missing indexes or indexes that
> are not being used.
>
>
>
> Thanks
>
>
>
>
>
>
>
> Julian Valoo
>
> SQL Database Administrator
>
> Corporate and Transactional Banking IT
>
> BankCity
>
> e-mail julian(dot)valoo(at)fnb(dot)co(dot)za
>
> www.fnb.co.za www.shine2010.co.za
>
>
>
>
>
>
> To read FirstRand Bank's Disclaimer for this email click on the following
> address or copy into your Internet browser:
> https://www.fnb.co.za/disclaimer.html
>
> If you are unable to access the Disclaimer, send a blank e-mail to
> firstrandbankdisclaimer(at)fnb(dot)co(dot)za and we will send you a copy of the
> Disclaimer.
>

--
Wysłane z mojego urządzenia przenośnego

Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/