Skip to content

Instantly share code, notes, and snippets.

@arockwell
Created August 17, 2010 19:51
Show Gist options
  • Select an option

  • Save arockwell/531693 to your computer and use it in GitHub Desktop.

Select an option

Save arockwell/531693 to your computer and use it in GitHub Desktop.
mysql> select table_schema, table_name, table_rows from information_schema.tables where (table_schema = 'hippo' or table_schema = 'vivoDB') and table_rows > 0 order by table_rows;
+--------------+-----------------+------------+
| table_schema | table_name | table_rows |
+--------------+-----------------+------------+
| hippo | jena_long_uri | 11 |
| vivoDB | jena_long_uri | 11 |
| hippo | jena_graph | 20 |
| vivoDB | jena_graph | 20 |
| hippo | jena_g20t7_stmt | 75 |
| hippo | jena_g20t3_stmt | 75 |
| hippo | jena_g20t5_stmt | 75 |
| hippo | jena_g20t1_stmt | 75 |
| hippo | jena_g4t1_stmt | 75 |
| vivoDB | jena_g20t1_stmt | 75 |
| hippo | jena_g3t1_stmt | 256 |
| vivoDB | jena_g3t1_stmt | 296 |
| vivoDB | jena_sys_stmt | 442 |
| hippo | jena_sys_stmt | 477 |
| vivoDB | jena_long_lit | 5706 |
| hippo | jena_long_lit | 7932 |
| hippo | jena_g14t1_stmt | 10703 |
| vivoDB | jena_g14t1_stmt | 10703 |
| vivoDB | jena_g15t1_stmt | 42164 |
| hippo | jena_g15t1_stmt | 44975 |
| hippo | jena_g9t1_stmt | 68065 |
| vivoDB | jena_g9t1_stmt | 68065 |
| vivoDB | jena_g18t1_stmt | 77526 |
| hippo | jena_g18t1_stmt | 77637 |
| vivoDB | jena_g10t1_stmt | 81432 |
| hippo | jena_g10t1_stmt | 81541 |
| hippo | jena_g8t1_stmt | 116536 |
| vivoDB | jena_g8t1_stmt | 116536 |
| hippo | jena_g5t1_stmt | 125478 |
| vivoDB | jena_g5t1_stmt | 126138 |
| vivoDB | jena_g17t1_stmt | 167022 |
| vivoDB | jena_g13t1_stmt | 167038 |
| hippo | jena_g13t1_stmt | 167225 |
| hippo | jena_g17t1_stmt | 167504 |
| vivoDB | jena_g2t1_stmt | 169826 |
| hippo | jena_g2t1_stmt | 191907 |
| hippo | jena_g22t1_stmt | 219372 |
| vivoDB | jena_g22t1_stmt | 221814 |
| vivoDB | jena_g6t1_stmt | 227424 |
| hippo | jena_g6t1_stmt | 227727 |
| hippo | jena_g7t1_stmt | 240926 |
| vivoDB | jena_g7t1_stmt | 241251 |
| hippo | jena_g22t5_stmt | 311796 |
| hippo | jena_g1t1_stmt | 431358 |
| vivoDB | jena_g1t1_stmt | 450854 |
| hippo | jena_g21t5_stmt | 1611174 |
| hippo | jena_g21t1_stmt | 1614287 |
| vivoDB | jena_g21t1_stmt | 1618986 |
+--------------+-----------------+------------+
48 rows in set (4.53 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment