Sha256: cdd48cd93d0163d82f169e35220cd92d63310960dde2206faf48840cef01e370

Contents?: true

Size: 254 Bytes

Versions: 52

Compression:

Stored size: 254 Bytes

Contents

/* List all the indexes with their corresponding tables and columns. */

SELECT
  schemaname,
  indexname,
  tablename,
  rtrim(split_part(indexdef, '(', 2), ')') as columns
FROM pg_indexes
where tablename in (select relname from pg_statio_user_tables);

Version data entries

52 entries across 52 versions & 1 rubygems

Version Path
ruby-pg-extras-4.13.0 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.12.2 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.12.1 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.12.0 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.11.0 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.10.0 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.9.0 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.8.1 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.7.2 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.7.1 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.7.0 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.6.0 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.5.1 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.5.0 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.4.4 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.4.3 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.4.2 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.4.1 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.4.0 lib/ruby_pg_extras/queries/indexes.sql
ruby-pg-extras-4.2.0 lib/ruby_pg_extras/queries/indexes.sql