perf_postgres Class Reference

Inheritance diagram for perf_postgres:

Public Member Functions
	perf_postgres (&$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://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#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 22 of file perf-postgres.inc.php.

Member Function Documentation

Explain()

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

Definition at line 124 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 102 of file perf-postgres.inc.php.

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

perf_postgres()

perf_postgres::perf_postgres

(

&

$conn

)

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

References adodb_perf\$conn.

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 30 of file perf-postgres.inc.php.

$optimizeTableHigh

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

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

Referenced by optimizeTable().

$optimizeTableLow

perf_postgres::$optimizeTableLow = 'VACUUM %s'

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

Referenced by optimizeTable().

$settings

perf_postgres::$settings

Definition at line 39 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 24 of file perf-postgres.inc.php.