\n"; if ( $action == "Reindex SMT Instance" ) { echo "Reindexing all indexes...."; $SQLQuery="select indexrelname from pg_statio_all_indexes where pg_statio_all_indexes.schemaname='public' order by indexrelname"; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); $SQLNumRows = pg_numrows($SQLQueryResults); if ( $SQLNumRows ) { for ( $loop=0 ; $loop != $SQLNumRows ; $loop++ ) { $SQLQueryResultsObject = pg_fetch_object($SQLQueryResults,$loop) or die(pg_errormessage()."
\n"); $starttime=time(); $SQLQuery="reindex index $SQLQueryResultsObject->indexrelname;"; $TempSQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); pg_freeresult($TempSQLQueryResults) or die(pg_errormessage() . "
\n"); $endtime=time(); echo "Reindex of $SQLQueryResultsObject->indexrelname done in " . ($starttime - $begintime) . " seconds.
\n " ; } } pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); echo "Finished!
\n"; } if ( $action == "Reindex TSyslog" ) { echo "Reindexing TSyslog...."; $SQLQuery="reindex index tsyslog_pkey ; reindex index host_Idx ;reindex index TSyslogDateTime_IDX ; reindex index TSyslHostID_Idx ; "; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); echo "Finished!
\n"; } if ( $action == "Reindex Syslog_TArchive" ) { echo "Reindexing Syslog_TArchive...."; $SQLQuery="reindex index syslog_tarchive_pkey ; reindex index archhost_idx ; reindex index tarchdatetime_idx ;"; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); echo "Finished!
\n"; } if ( $action == "Vacuum Entire Database" ) { echo "Conducting Vacuum...."; $SQLQuery="vacuum ANALYZE"; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); echo "Finished!
\n"; } if ( $action == "Analyze TSyslog Table" ) { echo "Conducting Analyze of TSyslog...."; $SQLQuery="ANALYZE TSyslog"; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); echo "Finished!
\n"; } if ( $action == "Analyze Syslog_TArchive Table" ) { echo "Conducting Analyze of Syslog_TArchive...."; $SQLQuery="ANALYZE Syslog_TArchive"; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); echo "Finished!
\n"; } if ( $action == "FULL Vacuum Entire Database" ) { echo "Conducting Full Vacuum of Entire Database...."; $SQLQuery="VACUUM FULL ANALYZE"; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery); die(pg_errormessage() . "
\n"); pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); echo "Finished!
\n"; } if ( ( $action == "View Unprocessed Log Breakdown" ) || ( $action == "View Archive Log Breakdown" ) ) { if ( $action == "View Unprocessed Log Breakdown" ) { $SQLQuery="select count(tsyslog_id), host from TSyslog group by host order by host"; } if ( $action == "View Archive Log Breakdown" ) { $SQLQuery="select count(tsyslog_id), host from Syslog_TArchive group by host order by host"; } $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); $SQLNumRows = pg_numrows($SQLQueryResults); if ( $SQLNumRows ) { echo "\n"; for ( $loop = ($SQLNumRows - 1) ; $loop != -1 ; $loop-- ) { $SQLQueryResultsObject = pg_fetch_object($SQLQueryResults,$loop) or die(pg_errormessage()."
\n"); $HostID=$hostid = relatedata($dbsocket,"Syslog_THost","THost_ID","THost_Host='$SQLQueryResultsObject->host'"); if ( $HostID > 0 ) { $HostProcessed=relatedata($dbsocket,"syslog_tprocessorprofile","THost_ID","THost_ID='$HostID'"); } else { $HostProcessed=0; } if ( $HostID > 0 ) { if ( $HostProcessed > 0 ) { echo "\n"; } else { echo "\n"; } } else { echo "\n"; } } echo "

Host	# of Records
$SQLQueryResultsObject->host	$SQLQueryResultsObject->count
$SQLQueryResultsObject->host	$SQLQueryResultsObject->count
$SQLQueryResultsObject->host	$SQLQueryResultsObject->count

\n"; } $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); } if ( $action == "Display Database Confguration" ) { echo "$action
\n"; $SQLQuery="select * from pg_settings"; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); $SQLNumRows = pg_numrows($SQLQueryResults); if ( $SQLNumRows ) { echo "\n"; for ( $loop = ($SQLNumRows - 1) ; $loop != -1 ; $loop-- ) { $SQLQueryResultsObject = pg_fetch_object($SQLQueryResults,$loop) or die(pg_errormessage()."
\n"); echo "\n"; } echo "

Name	Setting	Context	Vartype	Source	Min_Val	Max_Val
$SQLQueryResultsObject->name	$SQLQueryResultsObject->setting	$SQLQueryResultsObject->context	$SQLQueryResultsObject->vartype	$SQLQueryResultsObject->source	$SQLQueryResultsObject->min_val	$SQLQueryResultsObject->max_val

\n"; } pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); } if ( $action == "Display Current Locks" ) { echo "$action
\n"; $SQLQuery="select * from pg_locks;"; $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); $SQLNumRows = pg_numrows($SQLQueryResults); if ( $SQLNumRows ) { echo "\n"; for ( $loop = ($SQLNumRows - 1) ; $loop != -1 ; $loop-- ) { $SQLQueryResultsObject = pg_fetch_object($SQLQueryResults,$loop) or die(pg_errormessage()."
\n"); echo "\n"; } echo "

Relation	Database	Transaction	PID	Mode	Granted
$SQLQueryResultsObject->relation	$SQLQueryResultsObject->database	$SQLQueryResultsObject->transaction	$SQLQueryResultsObject->pid	$SQLQueryResultsObject->mode	$SQLQueryResultsObject->granted

\n"; } pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); } if ( ( $action == "Display Index Usage" ) || ( $action == "Display Relavent Table Usage" ) || ( $action == "Display SMT Table Usage" ) ) { echo "$action
\n"; $condition=""; $total=0; if ( $action == "Display Index Usage" ) { $SQLQuery="SELECT c2.relname, c2.relpages, c2.relkind FROM pg_class c, pg_class c2, pg_index i where c.oid = i.indrelid AND c2.oid = i.indexrelid ORDER BY c2.relname"; $title="Index Name"; } if ( $action == "Display SMT Table Usage" ) { $SQLQuery="select relname, relpages,relkind from pg_class where relkind='r' order by relname;"; $condition = "syslog"; $title="Table Name"; } if ( $action == "Display Relavent Table Usage" ) { $SQLQuery="SELECT relname, relpages,relkind FROM pg_class ORDER BY relpages;"; $title="Object Name"; } $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); $SQLNumRows = pg_numrows($SQLQueryResults); if ( $SQLNumRows ) { echo "\n"; for ( $loop = ($SQLNumRows - 1) ; $loop != -1 ; $loop-- ) { $SQLQueryResultsObject = pg_fetch_object($SQLQueryResults,$loop) or die(pg_errormessage()."
\n"); if ( $condition != "" ) { if ( ereg($condition,$SQLQueryResultsObject->relname) ) { echo "\n"; $total = $total + $SQLQueryResultsObject->relpages * 8192; } } else { echo "\n"; $total = $total + $SQLQueryResultsObject->relpages * 8192; } } echo "\n"; echo "

$title	Size(bytes)	Type
$SQLQueryResultsObject->relname	" . number_format($SQLQueryResultsObject->relpages * 8192) . "	"; if ( $SQLQueryResultsObject->relkind == 'r' ) { echo "Table";} if ( $SQLQueryResultsObject->relkind == 'i' ) { echo "Index";} if ( $SQLQueryResultsObject->relkind == 'S' ) { echo "Sequence";} if ( $SQLQueryResultsObject->relkind == 'v' ) { echo "View";} if ( $SQLQueryResultsObject->relkind == 'c' ) { echo "Composite";} if ( $SQLQueryResultsObject->relkind == 's' ) { echo "Special";} if ( $SQLQueryResultsObject->relkind == 't' ) { echo "Toast";} echo "
$SQLQueryResultsObject->relname	" . number_format($SQLQueryResultsObject->relpages * 8192) . "	"; if ( $SQLQueryResultsObject->relkind == 'r' ) { echo "Table";} if ( $SQLQueryResultsObject->relkind == 'i' ) { echo "Index";} if ( $SQLQueryResultsObject->relkind == 'S' ) { echo "Sequence";} if ( $SQLQueryResultsObject->relkind == 'v' ) { echo "View";} if ( $SQLQueryResultsObject->relkind == 'c' ) { echo "Composite";} if ( $SQLQueryResultsObject->relkind == 's' ) { echo "Special";} if ( $SQLQueryResultsObject->relkind == 't' ) { echo "Toast";} echo "
Total:	" . number_format($total) . "

\n"; } $SQLQueryResults = pg_exec($dbsocket,$SQLQuery) or die(pg_errormessage()."
\n"); pg_freeresult($SQLQueryResults) or die(pg_errormessage() . "
\n"); } closeform(); $endtime=time(); echo "
Page loaded in " . ($endtime - $begintime) . " seconds.
\n"; do_footer(); dbdisconnect($sec_dbsocket); dbdisconnect($dbsocket); php?>