Date: Mon, 25 Nov 2019 10:20:36 +0900
From: Michael Paquier <michael@paquier.xyz>
To: jsalsman@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: monitoring-stats.html is too impenetrable
Message-ID: <20191125012036.GC37821@paquier.xyz>
References: <157458791863.7229.15011272113637426410@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="PuGuTyElPB9bOcsM"
Content-Disposition: inline
In-Reply-To: <157458791863.7229.15011272113637426410@wrigleys.postgresql.org>
Precedence: bulk


--PuGuTyElPB9bOcsM
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Sun, Nov 24, 2019 at 09:31:58AM +0000, PG Doc comments form wrote:
> There needs to be a tutorial page explaining how to use pg_stat_all_tables
> to find missing indexes, or maybe just an example on monitoring-stats.html
> which is hopelessly inaccessible to a non-expert. I would have never been
> able to figure out anything close to the solution at
> https://www.reddit.com/r/PostgreSQL/comments/e0rx8l/i_was_missing_a_single_index_and_omgf_everything/
> from the existing docs.

Well, it may be as simple as that in some cases, but you also need to
consider other parameters in more complex cases, like:
- Actual CPU consumption done by backends.
- Get stats about predicates (WHERE and JOIN clauses).
- Physical disk access.
- Anything else I don't have on top of my mind.

> Thank you for your kind consideration of this
> request; please do not hesitate to send instructions for how to submit a
> pull request for this, as I would gladly do so. Best regards, -Jim

The Postgres mailing lists are old-school regarding that, so pull
requests sent to the git repository on github or such are not
accepted.  Sending an email with a patch would be just but fine, and
here you would need to patch some of the *.sgml files in doc/.  So if
you have anything you'd like to get changed with fresh ideas, let's
see how you would like things to change and then let's discuss about
it.

Thanks,
--
Michael

--PuGuTyElPB9bOcsM
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3bLGQACgkQnvQgOdby
QH3loxAAjAL4XF9jBmeZirRePWQsaah61SfTkMsJa4KHnPd7h9NA1uFwdNe+uuT7
75hLN/y3BAruCYZJgVXdsoARuMce+mov8Br9PlGJTXqycNQ0o5ERjovKUCM3wO4X
KerrDl8UAu3pozOGHj3mHzdF4oMAxOfWXU5Y+inCDiSwhcKcZ8EUA28BSQEkmplJ
Wu3dNT1Ka/P4z/O1sHSl1He2fCiDsePL3P/IWzosd9QFSapj+sO8o+6tteMz+KVk
cw2YZwS/Cors1OV4V7I53VzC3xpfPfI33vr5XAfvdCkgEiYyFSWBaojLpi08jpDg
6yVfhiFt+37gNmozZMyTWWkXXEufY3Nm3kQSvQMGECLtH+ZR5JtcYNcMZrtpqaDN
RiFplpLjcM8h4qynBdcrXKaK98UR9b3ypuGMa2dQDd2Qm3d1LX6wJ1DMvE3hL6jd
2YwLATe1COwhPO4eRBdBpQuq+frt9JUin/IE+gexL5rI5Ar4UVq+P19/nyu9oS1j
c3mj01dR+AOMXTeJM7+K+rnMsFUELHvJIba5NsOC7cRj/usxVHFYYy9ioCyCXajz
4ZvL7xtaQxMunoucJSY8MIXINe7x8tk5mpMP1npOuJ8YmMoVUUvCRxxuRbTb+xVK
v0sx5lrjADjNUmlHlcGo//PVjI/CwpOqOC6VtepnEl2dRutkHL8=
=bJfV
-----END PGP SIGNATURE-----

--PuGuTyElPB9bOcsM--