Il nostro punto della strada

User Tools

Site Tools

Trace:
sysadmin:postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
sysadmin:postgresql [2014/11/25 08:46] – Query per occupazione disco delle tabelle ferodasysadmin:postgresql [2014/11/25 08:48] – wiki syntax feroda
Line 90: Line 90:
           END           END
       )::bigint AS estimated_row_count       )::bigint AS estimated_row_count
- 
       FROM (       FROM (
- 
         SELECT table_schema, table_name,          SELECT table_schema, table_name, 
             pg_relation_size('"' || table_schema || '"."' || table_name || '"') as size,             pg_relation_size('"' || table_schema || '"."' || table_name || '"') as size,