"TYPO3 4.0.1: perf_postgres Class Reference", "datetime" => "Sat Dec 2 19:25:22 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

perf_postgres Class Reference

Inheritance diagram for perf_postgres:

Inheritance graph
[legend]
Collaboration diagram for perf_postgres:

Collaboration graph
[legend]
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.

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::$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: