Is there an equivalent for Oracle's user_tables.num_rows

Поиск

Список

Период

Сортировка

От	Virag Saksena
Тема	Is there an equivalent for Oracle's user_tables.num_rows
Дата	9 февраля 2007 г. 20:05:53
Msg-id	00aa01c74ca6$7392a160$2900000a@demo01 обсуждение исходный текст
Ответы	Re: Is there an equivalent for Oracle's user_tables.num_rows
Список	pgsql-performance

All,

I am looking to automate analyze table in my application.

I have some insert only tables in my application which I need to analyze as data grows.

Since the inserts are application controlled, I can choose to run analyze when I determine the

data has grown more than x% since last analyze.

However since users can truncate the tables too, I need to be able to tell the numbers of rows

in the table as perceived by the optimizer.

I could not decipher a good way of telling the number of table rows from pg_stats/pg_statistics.

Does someone know of a way of telling what the optimizer believes the number of rows are ?

The tables in question have multi-column primary keys.

Regards,

Virag

В списке pgsql-performance по дате отправления: