Re: Add min and max execute statement time in pg_stat_statement

From:	KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>
To:	PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Add min and max execute statement time in pg_stat_statement
Date:	2013-11-14 12:29:26
Message-ID:	5284C226.1010607@lab.ntt.co.jp
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2013-10-18 08:02:59 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp> 📎  2013-10-18 13:21:13 from Andrew Dunstan <andrew(at)dunslane(dot)net>   2013-10-21 11:17:53 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>    2013-10-21 19:52:16 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>     2013-10-21 20:01:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2013-10-21 20:36:41 from Robert Haas <robertmhaas(at)gmail(dot)com>       2013-10-21 20:43:28 from Peter Geoghegan <pg(at)heroku(dot)com>        2013-10-21 22:48:52 from Andrew Dunstan <andrew(at)dunslane(dot)net>         2013-10-21 23:29:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2013-10-21 23:44:41 from Andrew Dunstan <andrew(at)dunslane(dot)net>          2013-10-22 00:22:01 from Peter Geoghegan <pg(at)heroku(dot)com>          2013-10-22 09:56:47 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>           2013-10-22 10:11:14 from Daniel Farina <daniel(at)heroku(dot)com>           2013-10-22 11:03:23 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>           2013-10-22 13:26:43 from Stephen Frost <sfrost(at)snowman(dot)net>            2013-10-23 02:19:07 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>             2013-10-23 21:34:30 from Marc Mamin <M(dot)Mamin(at)intershop(dot)de> 📎              2013-10-23 21:57:18 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>               2013-10-23 22:26:09 from Peter Geoghegan <pg(at)heroku(dot)com>                2013-10-23 23:00:11 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>                 2013-10-23 23:07:09 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>                 2013-10-23 23:14:25 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>                  2013-10-23 23:24:41 from Peter Geoghegan <pg(at)heroku(dot)com>                   2013-10-23 23:34:33 from Stephen Frost <sfrost(at)snowman(dot)net>                    2013-10-23 23:48:22 from Peter Geoghegan <pg(at)heroku(dot)com>                   2013-10-23 23:48:13 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>                    2013-10-23 23:58:18 from Peter Geoghegan <pg(at)heroku(dot)com>                     2013-10-24 00:15:44 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>                      2013-10-24 00:25:22 from Peter Geoghegan <pg(at)heroku(dot)com>                  2013-10-23 23:26:28 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>                2013-10-23 23:06:35 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>          2013-10-22 18:16:19 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>           2013-10-22 19:13:26 from Josh Berkus <josh(at)agliodbs(dot)com>            2013-10-23 16:20:38 from Stephen Frost <sfrost(at)snowman(dot)net>             2013-10-23 20:07:51 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>              2013-10-23 20:17:53 from Stephen Frost <sfrost(at)snowman(dot)net>              2013-10-23 20:26:15 from Peter Geoghegan <pg(at)heroku(dot)com>               2013-10-23 23:46:12 from Josh Berkus <josh(at)agliodbs(dot)com>                2013-10-23 23:51:26 from Peter Geoghegan <pg(at)heroku(dot)com>                 2013-10-24 00:17:23 from Peter Geoghegan <pg(at)heroku(dot)com>                  2013-10-24 03:52:16 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                   2013-10-24 17:10:51 from Josh Berkus <josh(at)agliodbs(dot)com>                   2013-11-13 22:11:46 from Peter Geoghegan <pg(at)heroku(dot)com>                    2013-11-14 17:09:29 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>                     2013-11-15 02:24:31 from Peter Geoghegan <pg(at)heroku(dot)com>                     2013-11-15 03:33:48 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                    2013-11-15 02:28:26 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                     2013-11-15 02:31:35 from Peter Geoghegan <pg(at)heroku(dot)com>                      2013-11-15 03:32:45 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                       2014-01-21 11:54:54 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp> 📎                        2014-01-21 19:48:41 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                         2014-01-21 20:09:34 from Andrew Dunstan <andrew(at)dunslane(dot)net>                         2014-01-21 20:19:13 from Peter Geoghegan <pg(at)heroku(dot)com>                          2014-01-22 00:34:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                           2014-01-22 08:32:56 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                            2014-01-22 13:26:00 from Robert Haas <robertmhaas(at)gmail(dot)com>                             2014-01-23 01:28:39 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                              2014-01-23 01:28:58 from Peter Geoghegan <pg(at)heroku(dot)com>                               2014-01-23 12:43:22 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp> 📎                                2014-01-26 08:48:33 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                              2014-01-23 03:00:06 from Andrew Dunstan <andrew(at)dunslane(dot)net>                               2014-01-23 04:33:06 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                                2014-01-23 14:18:26 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                 2014-01-27 12:09:02 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                                  2014-01-27 12:45:18 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                   2014-01-27 13:48:16 from Mitsumasa KONDO <kondo(dot)mitsumasa(at)gmail(dot)com>                                    2014-01-27 15:23:22 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                   2014-01-27 21:37:10 from Peter Geoghegan <pg(at)heroku(dot)com>                                    2014-01-27 22:01:36 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                     2014-01-27 22:54:52 from Peter Geoghegan <pg(at)heroku(dot)com>                         2014-01-26 08:08:27 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                          2014-01-26 08:43:44 from Mitsumasa KONDO <kondo(dot)mitsumasa(at)gmail(dot)com>                           2014-01-27 12:16:59 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp> 📎                            2014-01-28 06:17:25 from Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>                             2014-01-28 10:23:53 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                              2014-01-29 06:51:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                               2014-01-29 07:58:17 from Peter Geoghegan <pg(at)heroku(dot)com>                                2014-01-29 09:16:54 from Magnus Hagander <magnus(at)hagander(dot)net>                                 2014-01-29 12:55:44 from Simon Riggs <simon(at)2ndQuadrant(dot)com>                                  2014-01-29 19:09:52 from Josh Berkus <josh(at)agliodbs(dot)com>                                2014-01-29 14:06:43 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                 2014-01-29 19:54:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                                  2014-01-29 20:07:47 from Josh Berkus <josh(at)agliodbs(dot)com>                                 2014-01-29 21:14:02 from Peter Geoghegan <pg(at)heroku(dot)com>                                  2014-01-29 21:32:30 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                   2014-01-29 23:29:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2014-01-30 10:21:12 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                                     2014-01-30 15:51:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                2014-01-30 04:48:10 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp> 📎                                 2014-01-30 10:25:18 from Peter Geoghegan <pg(at)heroku(dot)com>                                  2014-01-30 16:50:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                   2014-01-30 17:23:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2014-01-30 17:28:47 from Robert Haas <robertmhaas(at)gmail(dot)com>                                     2014-01-30 17:42:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                      2014-01-30 17:57:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                       2014-01-30 19:28:02 from Peter Geoghegan <pg(at)heroku(dot)com>                                        2014-01-30 20:32:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                         2014-01-30 21:22:29 from Peter Geoghegan <pg(at)heroku(dot)com>                                          2014-01-31 13:07:59 from Mitsumasa KONDO <kondo(dot)mitsumasa(at)gmail(dot)com>                                           2014-01-31 19:11:23 from Peter Geoghegan <pg(at)heroku(dot)com>                                            2014-01-31 21:00:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                               2014-01-29 08:03:54 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                                2014-01-29 09:14:50 from Magnus Hagander <magnus(at)hagander(dot)net>                              2014-01-29 08:31:54 from Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>                               2014-01-30 04:48:47 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                                2014-02-12 06:45:54 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp> 📎                                 2014-02-17 12:44:27 from Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>                                  2014-02-18 11:11:50 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                                 2014-03-04 09:38:01 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>                                  2014-04-07 17:43:30 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                   2014-04-07 20:19:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2014-04-08 03:59:37 from Robert Haas <robertmhaas(at)gmail(dot)com>                                     2014-04-08 04:22:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2014-12-21 16:05:10 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                     2014-12-21 18:23:27 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                      2014-12-21 18:25:43 from Andres Freund <andres(at)anarazel(dot)de>                                      2014-12-21 19:04:21 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                       2014-12-21 19:12:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                        2014-12-21 19:50:09 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                         2015-01-06 23:15:21 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                          2015-01-20 18:26:07 from Arne Scheffer <arne(dot)scheffer(at)uni-muenster(dot)de>                                           2015-01-20 22:30:53 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                            2015-01-20 23:32:17 from David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>                                             2015-01-20 23:54:15 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                              2015-01-21 14:16:11 from Arne Scheffer <arne(dot)scheffer(at)uni-muenster(dot)de>                                               2015-01-21 14:27:03 from Arne Scheffer <arne(dot)scheffer(at)uni-muenster(dot)de>                                                2015-01-21 14:46:53 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                 2015-01-21 16:21:01 from Arne Scheffer <scheffa(at)uni-muenster(dot)de>                                                  2015-01-21 16:32:57 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                   2015-01-21 16:58:23 from Arne Scheffer <arne(dot)scheffer(at)uni-muenster(dot)de>                                                   2015-02-17 00:44:48 from Petr Jelinek <petr(at)2ndquadrant(dot)com>                                                    2015-02-17 00:57:49 from Peter Geoghegan <pg(at)heroku(dot)com>                                                     2015-02-17 01:48:09 from Petr Jelinek <petr(at)2ndquadrant(dot)com>                                                      2015-02-17 01:57:08 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                       2015-02-17 02:03:45 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                        2015-02-17 02:07:36 from Petr Jelinek <petr(at)2ndquadrant(dot)com>                                                         2015-02-17 14:50:39 from Petr Jelinek <petr(at)2ndquadrant(dot)com>                                                          2015-02-17 15:12:06 from Andres Freund <andres(at)2ndquadrant(dot)com>                                                           2015-02-17 15:38:54 from Petr Jelinek <petr(at)2ndquadrant(dot)com>                                                       2015-02-17 02:05:13 from Petr Jelinek <petr(at)2ndquadrant(dot)com>                                                        2015-02-21 21:09:02 from Andrew Dunstan <andrew(at)dunslane(dot)net> 📎                                                         2015-02-22 00:59:41 from Petr Jelinek <petr(at)2ndquadrant(dot)com>                                                          2015-03-14 14:09:49 from Petr Jelinek <petr(at)2ndquadrant(dot)com>                                                         2015-03-20 09:34:57 from Andres Freund <andres(at)2ndquadrant(dot)com>                                             2015-01-21 12:18:04 from Arne Scheffer <arne(dot)scheffer(at)uni-muenster(dot)de>                                             2015-02-18 01:21:32 from Peter Eisentraut <peter_e(at)gmx(dot)net>                                              2015-02-18 15:11:31 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                              2015-02-19 01:34:39 from David Fetter <david(at)fetter(dot)org>                                               2015-02-19 01:50:45 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                2015-02-19 03:31:09 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                                 2015-02-19 18:10:54 from David Fetter <david(at)fetter(dot)org>                                                  2015-02-19 18:19:58 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                            2015-01-21 00:32:49 from Arne Scheffer <arne(dot)scheffer(at)uni-muenster(dot)de>                 2013-10-24 13:54:52 from Andrew Dunstan <andrew(at)dunslane(dot)net>                  2013-10-24 14:54:32 from Peter Geoghegan <pg(at)heroku(dot)com>                2013-10-23 23:55:42 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>           2013-10-23 21:46:01 from Martijn van Oosterhout <kleptog(at)svana(dot)org>            2013-10-23 21:53:47 from Peter Geoghegan <pg(at)heroku(dot)com>            2013-10-23 23:30:44 from Stephen Frost <sfrost(at)snowman(dot)net>       2013-10-21 23:09:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2013-10-22 18:33:08 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>      2013-10-21 21:47:15 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>       2013-10-21 22:09:26 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>        2013-10-22 00:26:29 from Ants Aasma <ants(at)cybertec(dot)at>         2013-10-22 00:47:10 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>         2013-10-22 01:00:39 from Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>          2013-10-22 01:23:06 from Ants Aasma <ants(at)cybertec(dot)at>    2013-11-14 12:25:12 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>     2013-11-14 12:29:26 from KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp> 📎      2013-11-20 11:27:54 from Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
pg_stat_statements-exectime_v1.patch	text/x-diff	16.5 KB

In response to

• Re: Add min and max execute statement time in pg_stat_statement at 2013-11-14 12:25:12 from KONDO Mitsumasa

Responses

• Re: Add min and max execute statement time in pg_stat_statement at 2013-11-20 11:27:54 from Rajeev rastogi

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	David Rowley	2013-11-14 12:38:26	Re: init_sequence spill to hash table
Previous Message	KONDO Mitsumasa	2013-11-14 12:25:12	Re: Add min and max execute statement time in pg_stat_statement