Silvio Brandani <silvio.brandani@xxxxxxxxxxx> wrote: > Our database seems not using index anymore, please help with, > is a production database. > > is there a script to check missing index on foreign key ?? You haven't provided enough information to allow anyone to help. http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin