private function psqlQuery(array $database)
    {
        // I couldn't find a way to run the SUM directly in the database query...
        $query = 'SELECT'
          . ' sum(pg_relation_size(pg_class.oid))::bigint AS size'
          . ' FROM pg_class'
          . ' LEFT OUTER JOIN pg_namespace ON (pg_namespace.oid = pg_class.relnamespace)'
          . ' GROUP BY pg_class.relkind, nspname'
          . ' ORDER BY sum(pg_relation_size(pg_class.oid)) DESC;';

        /** @var \Platformsh\Cli\Service\Relationships $relationships */
        $relationships = $this->getService('relationships');
        $dbUrl = $relationships->getDbCommandArgs('psql', $database, '');

        return sprintf(
            "psql --echo-hidden -t --no-align %s -c '%s'",
            $dbUrl,
            $query
        );
    }
private function psqlQuery(array $database)
    {
        // I couldn't find a way to run the SUM directly in the database query...
        $query = 'SELECT'
          . ' sum(pg_relation_size(pg_class.oid))::bigint AS size'
          . ' FROM pg_class'
          . ' LEFT OUTER JOIN pg_namespace ON (pg_namespace.oid = pg_class.relnamespace)'
          . ' GROUP BY pg_class.relkind, nspname'
          . ' ORDER BY sum(pg_relation_size(pg_class.oid)) DESC;';

        /** @var \Platformsh\Cli\Service\Relationships $relationships */
        $relationships = $this->getService('relationships');
        $dbUrl = $relationships->getDbCommandArgs('psql', $database, '');

        return sprintf(
            "psql --echo-hidden -t --no-align %s -c '%s'",
            $dbUrl,
            $query
        );
    }
private function psqlQuery ( array $ database ) { // I couldn't find a way to run the SUM directly in the database query... $ query = 'SELECT' . ' sum(pg_relation_size(pg_class.oid))::bigint AS size' . ' FROM pg_class' . ' LEFT OUTER JOIN pg_namespace ON (pg_namespace.oid = pg_class.relnamespace)' . ' GROUP BY pg_class.relkind, nspname' . ' ORDER BY sum(pg_relation_size(pg_class.oid)) DESC;' ; /** @var \Platformsh\Cli\Service\Relationships $relationships */ $ relationships = $ this -> getService ( 'relationships' ) ; $ dbUrl = $ relationships -> getDbCommandArgs ( 'psql' , $ database , '' ) ; return sprintf ( "psql --echo-hidden -t --no-align %s -c '%s'" , $ dbUrl , $ query ) ; }
Returns a command to query disk usage for a PostgreSQL database.

@param array $database The database connection details.

@return string
Returns a command to query disk usage for a PostgreSQL database .