New answers tagged

0

As a horse_with_no_name provided, you can search the pg_indexes meta-table to find an index by name with the query: SELECT * FROM pg_indexes WHERE indexname LIKE '%NameOfIndexYoureSearchingFor%'; Regarding your second question in the comments on how to delete an index in PostgreSQL, you can script it out with a query like this: DROP INDEX ...


0

I came up with this query that returns the same columns as PGAdmin III Status Activity window but alas there is no color-coding of queries running longer than 5-10 seconds and no button that will terminate the query or the connection. select pid as process_id, application_name, datname as Database, usename as username, client_addr as client_address, ...


Top 50 recent answers are included