On 04/10/2013 06:31 AM, Zahid Quadri wrote:
> please suggest if there is any way which i can find which tables need
> indexes in postgresql.
If you have 8.4 or newer, you can look in pg_stat_statements for queries
that use a lot of time. Check the where clauses for columns or
transforms that can be indexed.
Of course, you have to install it first. Take a look here:
http://www.postgresql.org/docs/8.4/static/pgstatstatements.html
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email