Bubble charts encode data in the area of circles. Although less perceptually-accurate than bar charts, they can pack hundreds of values into a small space. Implementation based on work by Jeff Heer. Data shows the Flare class hierarchy, also courtesy Jeff Heer.
Mike Mattozzi mmattozzi
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| license: gpl-3.0 |
mmattozzi
/ List postgres indexes and sizes
Last active
December 15, 2015 12:09
— forked from next2you/Postgres Index Usage.sql
Displaying indexes in a postgres db
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT idx.relname as table, | |
| idx.indexrelname as index, | |
| pg_relation_size( idx.indexrelname::text ) 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 , |