Event Timeline
softwareheritage=> begin;
BEGIN
softwareheritage=>
softwareheritage=> create or replace function swh_count_total_indexes_size()
softwareheritage-> returns bigint
softwareheritage-> language plpgsql
softwareheritage-> as $$
softwareheritage$> declare
softwareheritage$> s bigint;
softwareheritage$> l bigint;
softwareheritage$> t text;
softwareheritage$> begin
softwareheritage$> s := 0;
softwareheritage$>
softwareheritage$> for t in
softwareheritage$> select distinct tablename from pg_tables where schemaname='public'
softwareheritage$> loop
softwareheritage$> select pg_indexes_size(t) into l;
softwareheritage$> s := s + l;
softwareheritage$> end loop;
softwareheritage$>
softwareheritage$> return s;
softwareheritage$> end
softwareheritage$> $$;
CREATE FUNCTION
softwareheritage=>
softwareheritage=> select pg_size_pretty(swh_count_total_indexes_size());
pg_size_pretty
4233 GB
(1 row)
softwareheritage=>
softwareheritage=> rollback;
ROLLBACK