gehe zur Dokumentation dieser Datei
17 if (!defined(
'ADODB_DIR')) die();
25 "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
26 on b.relname = 'pg_toast_'||trim(a.relfilenode)
27 left join pg_class c on c.relname = 'pg_toast_'||trim(a.relfilenode)||'_index'
28 where a.relname in (select tablename from pg_tables where tablename not like 'pg_%')";
31 created timestamp NOT NULL,
32 sql0 varchar(250) NOT NULL,
36 timer decimal(16,6) NOT NULL
41 'statistics collector' => array(
'RATIO',
42 "select case when count(*)=3 then 'TRUE' else 'FALSE' end from pg_settings where (name='stats_block_level' or name='stats_row_level' or name='stats_start_collector') and setting='on' ",
43 'Value must be TRUE to enable hit ratio statistics (<i>stats_start_collector</i>,<i>stats_row_level</i> and <i>stats_block_level</i> must be set to true in postgresql.conf)'),
44 'data cache hit ratio' => array(
'RATIO',
45 "select case when blks_hit=0 then 0 else round( ((1-blks_read::float/blks_hit)*100)::numeric, 2) end from pg_stat_database where datname='\$DATABASE'",
48 'data reads' => array(
'IO',
49 'select sum(heap_blks_read+toast_blks_read) from pg_statio_user_tables',
51 'data writes' => array(
'IO',
52 'select round((sum(n_tup_ins/4.0+n_tup_upd/8.0+n_tup_del/4.0)/16)::numeric,2) from pg_stat_user_tables',
53 'Count of inserts/updates/deletes * coef'),
56 'data cache buffers' => array(
'DATAC',
57 "select setting from pg_settings where name='shared_buffers'",
58 'Number of cache buffers. <a href=http://www.varlena.com/GeneralBits/Tidbits/perf.html#basic>Tuning</a>'),
59 'cache blocksize' => array(
'DATAC',
62 'data cache size' => array(
'DATAC',
63 "select setting::integer*8192 from pg_settings where name='shared_buffers'",
65 'operating system cache size' => array(
'DATA',
66 "select setting::integer*8192 from pg_settings where name='effective_cache_size'",
67 '(effective cache size)' ),
69 # Postgres 7.5 changelog: Rename server parameters SortMem and VacuumMem to work_mem and maintenance_work_mem;
70 'sort/work buffer size' => array(
'CACHE',
71 "select setting::integer*1024 from pg_settings where name='sort_mem' or name = 'work_mem' order by name",
72 'Size of sort buffer (per query)' ),
74 'current connections' => array(
'SESS',
75 'select count(*) from pg_stat_activity',
77 'max connections' => array(
'SESS',
78 "select setting from pg_settings where name='max_connections'",
81 'rollback buffers' => array(
'COST',
82 "select setting from pg_settings where name='wal_buffers'",
84 'random page cost' => array(
'COST',
85 "select setting from pg_settings where name='random_page_cost'",
86 'Cost of doing a seek (default=4). See <a href=http://www.varlena.com/GeneralBits/Tidbits/perf.html#less>random_page_cost</a>'),
104 if(! is_string(
$table))
return false;
107 if (!
$conn)
return false;
115 ADOConnection::outp(sprintf(
"<p>%s: '%s' using of undefined mode '%s'</p>", __CLASS__,
'optimizeTable', $mode));
119 $sql = sprintf($sql,
$table);
121 return $conn->Execute($sql) !==
false;
126 $save = $this->conn->LogSQL(
false);
129 $sqlq = $this->conn->qstr($sql.
'%');
130 $arr = $this->conn->GetArray(
"select distinct distinct sql1 from adodb_logsql where sql1 like $sqlq");
132 foreach($arr as $row) {
134 if (crc32($sql) == $partial)
break;
138 $sql = str_replace(
'?',
"''",$sql);
139 $s =
'<p><b>Explain</b>: '.htmlspecialchars($sql).
'</p>';
140 $rs = $this->conn->Execute(
'EXPLAIN '.$sql);
141 $this->conn->LogSQL($save);
145 $s .= reset($rs->fields).
"\n";
149 $s .= $this->
Tracer($sql,$partial);
Sie sind hier: Home » MyOOS Benutzerhandbuch » ADOdb
Korrekturen, Hinweise und Ergänzungen
Bitte scheuen Sie sich nicht und melden Sie, was auf dieser Seite sachlich falsch oder irreführend ist, was ergänzt werden sollte, was fehlt usw. Dazu bitte oben aus dem Menü Seite den Eintrag
Support Forum wählen. Es ist eine kostenlose Anmeldung erforderlich, um Anmerkungen zu posten. Unpassende Postings, Spam usw. werden kommentarlos entfernt.