perf_postgres Class Reference

Inheritance diagram for perf_postgres:

Collaboration diagram for perf_postgres:

Public Member Functions
	perf_postgres (&$conn)
	optimizeTable ($table, $mode=ADODB_OPT_LOW)
	Explain ($sql, $partial=false)
Data Fields
	$tablesSQL
	$createTableSQL
	$settings
	$optimizeTableLow = 'VACUUM %s'
	$optimizeTableHigh = 'VACUUM ANALYZE %s'

---

Detailed Description

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

---

Member Function Documentation

Explain	(	$	sql,
		$	partial = false
	)

Reimplemented from adodb_perf.

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

Here is the call graph for this function:

optimizeTable	(	$	table,
		$	mode = ADODB_OPT_LOW
	)

See also:

adodb_perf::optimizeTable

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

perf_postgres

(

&$

conn

)

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

---

Field Documentation

$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
                )"

Reimplemented from adodb_perf.

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

$optimizeTableHigh = 'VACUUM ANALYZE %s'

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

$optimizeTableLow = 'VACUUM %s'

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

$settings

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

$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_%')"

Reimplemented from adodb_perf.

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

---

The documentation for this class was generated from the following file:

• C:/xampp/htdocs/moodle/lib/adodb/perf/perf-postgres.inc.php