pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How to see/calculate size of index in memory? 2+ messages / 2 participants [nested] [flat]
* How to see/calculate size of index in memory? @ 2018-09-19 08:30 Sam R. <samruohola@yahoo.com> 0 siblings, 1 reply; 2+ messages in thread From: Sam R. @ 2018-09-19 08:30 UTC (permalink / raw) To: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org> Hi! I would have following question, if someone could help. Question 1: How to see/calculate size of index in memory? BTree, hash index. I can see size of index e.g. with pg_relation_size FROM pg_class (after reindex). Does that tell size of index on disk? I would be interested how big part of index is in memory. (Whole index?) PG10/PG11. Best Regards, Sam ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to see/calculate size of index in memory? @ 2018-09-19 08:42 Sergei Kornilov <sk@zsrv.org> parent: Sam R. <samruohola@yahoo.com> 0 siblings, 0 replies; 2+ messages in thread From: Sergei Kornilov @ 2018-09-19 08:42 UTC (permalink / raw) To: Sam R. <samruohola@yahoo.com>; pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org> Hello You can use pg_buffercache contrib module: https://www.postgresql.org/docs/current/static/pgbuffercache.html pg_relation_size - yes, its full size on disk regardless buffer cache regards, Sergei ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-09-19 08:42 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-09-19 08:30 How to see/calculate size of index in memory? Sam R. <samruohola@yahoo.com> 2018-09-19 08:42 ` Sergei Kornilov <sk@zsrv.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox