Documentation TYPO3 par Ameos

perf_postgres Class Reference

Inheritance diagram for perf_postgres:
[legend]
Collaboration diagram for perf_postgres:
[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::$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.

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.


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


Généré par Les experts TYPO3 avec  doxygen 1.4.6