• Home
• Projects
• Gallery
• Code Lab
• Portfolio
• Contact

• PostgreSQL with PHP and ODBC
• How to force PHP to display all the error messages
• PostgreSQL get junk table names
• PostgreSQL Select tables' names
• Web application development questions and answers
• Multithread Swing programming [Java]
• PHP, MySQL and UTF-8
• Multiple images in a single PHP file
• Simulating Regiser Globals (PHP)
• How to get file extension [PHP]
• How to format filesize [PHP]
• CHMOD wrapping class [PHP]
• How to make IE and FF to run out of memory [JavaScript]
• SVN Externals
• PHP How to get file's real location
• CodeIgniter Polish transtation
• Java Sorting Algorithms
• WSU Khepera Simulator
• Postgres - How to check if plpgsql is installed
• Macromedia Flash MX - Drawing methods
• 3d in Macromedia Flash MX

Code Lab » PostgreSQL get junk table names

PostgreSQL - Get junk table names

The following code returns unused Postgres tables.

SELECT pg_stat_user_tables.relname
FROM pg_stat_user_tables, pg_statio_user_tables
WHERE

	pg_statio_user_tables.schemaname='public'
AND
	(pg_statio_user_tables.heap_blks_read=0
	OR
	pg_statio_user_tables.heap_blks_read IS NULL)
AND
	pg_stat_user_tables.n_tup_ins=0 
AND
	pg_stat_user_tables.n_tup_del=0 
AND
	pg_stat_user_tables.n_tup_upd=0
AND
	pg_statio_user_tables.relname=pg_stat_user_tables.relname