Re: PL/PgSQL for counting all rows in all tables. - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: PL/PgSQL for counting all rows in all tables.
Date
Msg-id da437c9a6579f2426b3324b485c193ab@biglumber.com
Whole thread Raw
In response to PL/PgSQL for counting all rows in all tables.  (David Fetter <david@fetter.org>)
Responses Re: PL/PgSQL for counting all rows in all tables.  (Ian FREISLICH <if@hetzner.co.za>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
My version:
ANALYZE;
SELECT n.nspname, relname, reltuples
FROM pg_class c, pg_namespace n
WHERE c.relnamespace=n.oid
AND relkind='r'
AND NOT n.nspname ~ '^pg_'
ORDER BY 1,2;
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200409282138
-----BEGIN PGP SIGNATURE-----
iD8DBQFBWhIivJuQZxSWSsgRAm3cAJwLySzR5mpOHDT06LN6vj9M5zyyOQCgt4j1
gWDPcXJoUZbTlZvxxrE7fcY=
=MOMs
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: PL/PgSQL for counting all rows in all tables.
Next
From: Karel Zak
Date:
Subject: Re: tweaking MemSet() performance - 7.4.5