perf_postgres Class Reference

Inheritance diagram for perf_postgres:

adodb_perf List of all members.

Public Member Functions

 perf_postgres (&$conn)
 Explain ($sql, $partial=false)

Public Attributes

 $tablesSQL
 $createTableSQL
 $settings

Detailed Description

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


Constructor & Destructor Documentation

perf_postgres.perf_postgres &$  conn  ) 
 

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


Member Function Documentation

perf_postgres.Explain sql,
partial = false
 

Reimplemented from adodb_perf.

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


Member Data Documentation

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

Reimplemented from adodb_perf.

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

perf_postgres.$settings
 

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

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

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:
Generated on Fri Apr 7 10:48:49 2006 for TYPO3 by  doxygen 1.4.6