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@xxxxxxxxxxxxxxxx ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
