perf_postgres Class Reference

Inheritance diagram for perf_postgres:

Public Member Functions
	__construct (&$conn)
	optimizeTable ($table, $mode=ADODB_OPT_LOW)
	Explain ($sql, $partial=false)
Public Member Functions inherited from adodb_perf
	_CPULoad ()
	MemInfo ()
	CPULoad ()
	Tracer ($sql)
	Explain ($sql, $partial=false)
	InvalidSQL ($numsql=10)
	_SuspiciousSQL ($numsql=10)
	CheckMemory ()
	SuspiciousSQL ($numsql=10)
	ExpensiveSQL ($numsql=10)
	_ExpensiveSQL ($numsql=10)
	DBParameter ($param)
	PollParameters ()
	_DBParameter ($sql)
	WarnCacheRatio ($val)
	clearsql ()
	UI ($pollsecs=5)
	Poll ($secs=5)
	HealthCheckCLI ()
	HealthCheck ($cli=false)
	Tables ($orderby='1')
	CreateLogTable ()
	DoSQLForm ()
	SplitSQL ($sql)
	undomq ($m)
	OptimizeTables ()
	OptimizeTable ( $table, $mode=ADODB_OPT_LOW)
	optimizeDatabase ()

Public Attributes
	$tablesSQL
	$createTableSQL
	$settings
	$optimizeTableLow = 'VACUUM %s'
	$optimizeTableHigh = 'VACUUM ANALYZE %s'
Public Attributes inherited from adodb_perf
	$conn
	$color = '#F0F0F0'
	$table = '<table border=1 bgcolor=white>'
	$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'
	$warnRatio = 90
	$tablesSQL = false
	$cliFormat = "%32s => %s \r\n"
	$sql1 = 'sql1'
	$explain = true
	$helpurl = '<a href="http://adodb.sourceforge.net/docs-adodb.htm#logsql">LogSQL help</a>'
	$createTableSQL = false
	$maxLength = 2000
	$_lastLoad

Additional Inherited Members
Static Public Member Functions inherited from adodb_perf
static	table ($newtable=false)

Detailed Description

Definition at line 24 of file perf-postgres.inc.php.

Constructor & Destructor Documentation

__construct()

perf_postgres::__construct

(

&

$conn

)

Definition at line 92 of file perf-postgres.inc.php.

References adodb_perf\$conn.

Member Function Documentation

Explain()

perf_postgres::Explain	(		$sql,
			$partial = false
	)

Definition at line 126 of file perf-postgres.inc.php.

References $rs, $sql, and adodb_perf\Tracer().

optimizeTable()

perf_postgres::optimizeTable	(		$table,
			$mode = ADODB_OPT_LOW
	)

See also

adodb_perf::optimizeTable

Definition at line 104 of file perf-postgres.inc.php.

References adodb_perf\$conn, $optimizeTableHigh, $optimizeTableLow, $sql, adodb_perf\$table, ADODB_OPT_HIGH, and ADODB_OPT_LOW.

Member Data Documentation

$createTableSQL

perf_postgres::$createTableSQL

Initial value:

= "CREATE TABLE adodb_logsql (
          created timestamp NOT NULL,
          sql0 varchar(250) NOT NULL,
          sql1 text NOT NULL,
          params text NOT NULL,
          tracer text NOT NULL,
          timer decimal(16,6) NOT NULL
        )"

Definition at line 32 of file perf-postgres.inc.php.

$optimizeTableHigh

perf_postgres::$optimizeTableHigh = 'VACUUM ANALYZE %s'

Definition at line 98 of file perf-postgres.inc.php.

Referenced by optimizeTable().

$optimizeTableLow

perf_postgres::$optimizeTableLow = 'VACUUM %s'

Definition at line 97 of file perf-postgres.inc.php.

Referenced by optimizeTable().

$settings

perf_postgres::$settings

Definition at line 41 of file perf-postgres.inc.php.

$tablesSQL

perf_postgres::$tablesSQL

Initial value:

=
    "select a.relname as tablename,(a.relpages+CASE WHEN b.relpages is null THEN 0 ELSE b.relpages END+CASE WHEN c.relpages is null THEN 0 ELSE c.relpages END)*8 as size_in_K,a.relfilenode as \"OID\"  from pg_class a left join pg_class b
        on b.relname = 'pg_toast_'||trim(a.relfilenode)
        left join pg_class c on c.relname = 'pg_toast_'||trim(a.relfilenode)||'_index'
        where a.relname in (select tablename from pg_tables where tablename not like 'pg_%')"

Definition at line 26 of file perf-postgres.inc.php.