Need feedback on possible new feature
От | Martijn van Oosterhout |
---|---|
Тема | Need feedback on possible new feature |
Дата | |
Msg-id | 20010714201236.D11863@svana.org обсуждение исходный текст |
Ответы |
Re: Need feedback on possible new feature
|
Список | pgsql-general |
Whether it's useful for anyone else is a question, but anyway, it makes an explain type output like: Aggregate (cost=183599.26..185497.00 rows=18977 width=116) actual (time=114.01..117.69 rows=61 loops=1) -> Group (cost=183599.26..185022.57 rows=189774 width=116) actual (time=1.86..1.93 rows=3528 loops=61) -> Sort (cost=183599.26..183599.26 rows=189774 width=116) actual (time=113.41..117.69 rows=215210 loops=1) -> Merge Join (cost=134957.25..138521.82 rows=189774 width=116) actual (time=83.79..96.92 rows=215210 loops=1) etc.. It shows the actual time taken to execute various parts of the query. Does anyone think this is useful? Needs some tweaking still. How should you invoke it? The ideas I have are: EXPLAIN TRUTHFULLY [query] ANALYZE [query] SELECT WITH STATISTICS Ideas? -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > It would be nice if someone came up with a certification system that > actually separated those who can barely regurgitate what they crammed over > the last few weeks from those who command secret ninja networking powers.
В списке pgsql-general по дате отправления: