method dbSize documentation in bbn\Db\Languages\Pgsql

Gets the size of a database

function(string $database = '', string $type = '') { if ($database && ($this->getCurrent() !== $database)) { return $this->newInstance( array_merge($this->cfg, ['db' => $database]) ) ->dbSize($database, $type); } $size = 0; if ($tables = $this->getTables()) { if ($type === 'data') { $function = "pg_relation_size"; } elseif ($type === 'index') { $function = "pg_indexes_size"; } else { $function = "pg_total_relation_size"; } $query = "SELECT "; $args = []; foreach ($tables as $table) { $query .= "$function(?), "; $args[] = $table; } $table_sizes = $this->getRow(trim($query, ', '), ...$args); foreach ($table_sizes as $table_size) { $size += $table_size; } } return $size; }

Gets the size of a database BBN is a suite of PHP and JS libraries and VueJS components - all open-source! bbn.io, build applications, the quick way

This website uses cookies to ensure you get the best experience on our website.