blob: 61385633ed944b12e2913d30eb33374d4c3146d7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
<?php
/**
* PHPPgAdmin v6.0.0-RC8
*/
namespace PHPPgAdmin\Database\Traits;
/**
* Common trait to retrieve stats on database objects.
*/
trait StatsTrait
{
/**
* Fetches statistics for a database.
*
* @param string $database The database to fetch stats for
*
* @return \PHPPgAdmin\ADORecordSet A recordset
*/
public function getStatsDatabase($database)
{
$this->clean($database);
$sql = "SELECT * FROM pg_stat_database WHERE datname='{$database}'";
return $this->selectSet($sql);
}
/**
* Fetches tuple statistics for a table.
*
* @param string $table The table to fetch stats for
*
* @return \PHPPgAdmin\ADORecordSet A recordset
*/
public function getStatsTableTuples($table)
{
$c_schema = $this->_schema;
$this->clean($c_schema);
$this->clean($table);
$sql = "SELECT * FROM pg_stat_all_tables
WHERE schemaname='{$c_schema}' AND relname='{$table}'";
return $this->selectSet($sql);
}
/**
* Fetches I/0 statistics for a table.
*
* @param string $table The table to fetch stats for
*
* @return \PHPPgAdmin\ADORecordSet A recordset
*/
public function getStatsTableIO($table)
{
$c_schema = $this->_schema;
$this->clean($c_schema);
$this->clean($table);
$sql = "SELECT * FROM pg_statio_all_tables
WHERE schemaname='{$c_schema}' AND relname='{$table}'";
return $this->selectSet($sql);
}
/**
* Fetches tuple statistics for all indexes on a table.
*
* @param string $table The table to fetch index stats for
*
* @return \PHPPgAdmin\ADORecordSet A recordset
*/
public function getStatsIndexTuples($table)
{
$c_schema = $this->_schema;
$this->clean($c_schema);
$this->clean($table);
$sql = "SELECT * FROM pg_stat_all_indexes
WHERE schemaname='{$c_schema}' AND relname='{$table}' ORDER BY indexrelname";
return $this->selectSet($sql);
}
/**
* Fetches I/0 statistics for all indexes on a table.
*
* @param string $table The table to fetch index stats for
*
* @return \PHPPgAdmin\ADORecordSet A recordset
*/
public function getStatsIndexIO($table)
{
$c_schema = $this->_schema;
$this->clean($c_schema);
$this->clean($table);
$sql = "SELECT * FROM pg_statio_all_indexes
WHERE schemaname='{$c_schema}' AND relname='{$table}'
ORDER BY indexrelname";
return $this->selectSet($sql);
}
abstract public function fieldClean(&$str);
abstract public function beginTransaction();
abstract public function rollbackTransaction();
abstract public function endTransaction();
abstract public function execute($sql);
abstract public function setComment($obj_type, $obj_name, $table, $comment, $basetype = null);
abstract public function selectSet($sql);
abstract public function clean(&$str);
abstract public function phpBool($parameter);
abstract public function hasCreateTableLikeWithConstraints();
abstract public function hasCreateTableLikeWithIndexes();
abstract public function hasTablespaces();
abstract public function delete($table, $conditions, $schema = '');
abstract public function fieldArrayClean(&$arr);
abstract public function hasCreateFieldWithConstraints();
abstract public function getAttributeNames($table, $atts);
}
|
