summaryrefslogtreecommitdiff
path: root/app/Models/DatabaseDAOPGSQL.php
diff options
context:
space:
mode:
authorGravatar Alexandre Alapetite <alexandre@alapetite.fr> 2022-03-03 14:28:17 +0100
committerGravatar GitHub <noreply@github.com> 2022-03-03 14:28:17 +0100
commit5eaefe0c9ce269cbe1cccccfad4941d54336f43b (patch)
treea4f308d9cb353f687711fbd1386061ee3fd13f3d /app/Models/DatabaseDAOPGSQL.php
parent12000df805491c8a840c9c2134bf1d460324171a (diff)
Fix PostgreSQL size calculation (#4249)
Regression from https://github.com/FreshRSS/FreshRSS/pull/3488
Diffstat (limited to 'app/Models/DatabaseDAOPGSQL.php')
-rw-r--r--app/Models/DatabaseDAOPGSQL.php10
1 files changed, 5 insertions, 5 deletions
diff --git a/app/Models/DatabaseDAOPGSQL.php b/app/Models/DatabaseDAOPGSQL.php
index 83332a027..6ff706250 100644
--- a/app/Models/DatabaseDAOPGSQL.php
+++ b/app/Models/DatabaseDAOPGSQL.php
@@ -59,11 +59,11 @@ class FreshRSS_DatabaseDAOPGSQL extends FreshRSS_DatabaseDAOSQLite {
} else {
$sql = <<<SQL
SELECT
-pg_total_relation_size('`{$this->pdo->prefix()}category`')
-pg_total_relation_size('`{$this->pdo->prefix()}feed`')
-pg_total_relation_size('`{$this->pdo->prefix()}entry`')
-pg_total_relation_size('`{$this->pdo->prefix()}entrytmp`')
-pg_total_relation_size('`{$this->pdo->prefix()}tag`')
+pg_total_relation_size('`{$this->pdo->prefix()}category`') +
+pg_total_relation_size('`{$this->pdo->prefix()}feed`') +
+pg_total_relation_size('`{$this->pdo->prefix()}entry`') +
+pg_total_relation_size('`{$this->pdo->prefix()}entrytmp`') +
+pg_total_relation_size('`{$this->pdo->prefix()}tag`') +
pg_total_relation_size('`{$this->pdo->prefix()}entrytag`')
SQL;
$stm = $this->pdo->query($sql);