Re: progress report for ANALYZE
От | Tatsuro Yamada |
---|---|
Тема | Re: progress report for ANALYZE |
Дата | |
Msg-id | 45d376f2-c690-c1b7-24d9-36edbcc1494e@nttcom.co.jp обсуждение исходный текст |
Ответ на | Re: progress report for ANALYZE (Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>) |
Ответы |
Re: progress report for ANALYZE
|
Список | pgsql-hackers |
Hi Alvaro, > I'll review your patch in this week. :) I tested your patch on 6b854896. Here is a result. See below: --------------------------------------------------------- [Session #1] create table hoge as select * from generate_series(1, 1000000) a; analyze verbose hoge; [Session #2] \a \t select * from pg_stat_progress_analyze; \watch 0.001 17520|13599|postgres|16387|f|16387|scanning table|4425|14 17520|13599|postgres|16387|f|16387|scanning table|4425|64 17520|13599|postgres|16387|f|16387|scanning table|4425|111 ... 17520|13599|postgres|16387|f|16387|scanning table|4425|4425 17520|13599|postgres|16387|f|16387|scanning table|4425|4425 17520|13599|postgres|16387|f|16387|scanning table|4425|4425 17520|13599|postgres|16387|f|16387|analyzing sample|0|0 17520|13599|postgres|16387|f|16387||0|0 <-- Is it Okay?? --------------------------------------------------------- I have a question of the last line of the result. I'm not sure it is able or not, but I guess it would be better to keep the phase name (analyzing sample) on the view until the end of this command. :) Regards, Tatsuro Yamada
В списке pgsql-hackers по дате отправления: