Argh. Attached is a plain text file with that query data. I'll be
switching back to Gnus any day now.
daeqck898dvduj=> select ev_class::regclass, length(ev_action)
rewrite_len,length(pg_get_viewdef(ev_class,true)) prettyprint_len,
length(pg_get_viewdef(ev_class,false)) non_prettyprint_len from pg_rewrite
order by 2 desc limit 20;
ev_class | rewrite_len | prettyprint_len |
non_prettyprint_len
--------------------------------------------+-------------+-----------------+---------------------
pg_seclabels | 138565 | 13528 |
13758
information_schema.columns | 126787 | 6401 |
6642
information_schema.usage_privileges | 93863 | 11653 |
11939
information_schema.attributes | 83268 | 4264 |
4417
information_schema.referential_constraints | 81762 | 2527 |
2653
pg_statio_all_tables | 59617 | 1023 |
1061
pg_stats | 59331 | 2803 |
2899
information_schema.domains | 54611 | 3206 |
3320
information_schema.element_types | 53049 | 5608 |
5762
information_schema.routines | 52333 | 7852 |
8089
information_schema.column_privileges | 49229 | 3883 |
3954
pg_indexes | 46717 | 458 |
486
information_schema.check_constraints | 42132 | 1375 |
1443
information_schema.tables | 37458 | 2122 |
2212
pg_stat_all_indexes | 35426 | 508 |
528
pg_statio_all_indexes | 35412 | 490 |
512
information_schema.table_constraints | 31882 | 3098 |
3231
information_schema.column_udt_usage | 31731 | 1034 |
1090
information_schema.parameters | 30497 | 3640 |
3750
pg_stat_all_tables | 27193 | 1367 |
1387
(20 rows)
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
