Skip to content

Instantly share code, notes, and snippets.

Christian van der Leeden next2you

  • Scoreloop AG
  • Munich, Germany
Block or report user

Report or block next2you

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
next2you / Postgres Index Usage.sql
Created Oct 15, 2010 — forked from sriedel/Postgres Index Usage
Postgres: Determine table/index size
View Postgres Index Usage.sql
SELECT idx.relname as table,
idx.indexrelname as index,
pg_relation_size( idx.indexrelname::text )/1024/1024 as bytes,
cls.relpages as pages,
cls.reltuples as tuples,
idx.idx_scan as scanned,
idx.idx_tup_read as read,
idx.idx_tup_fetch as fetched
FROM pg_stat_user_indexes idx,
pg_class cls ,
You can’t perform that action at this time.