SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 12:55 AM
| ||||
| ||||
 Re: pgstattuple extension for indexes nagayasu-san, This looks good, but we would like the code added to /contrib/pgstattuple, rather than it being its own /contrib module. Can you make that adjustment? Thanks. --------------------------------------------------------------------------- satoshi nagayasu wrote: > Hi folks, > > As I said on -PATCHES, I've been working on an utility to get > a b-tree index information. I'm happy to introduce > my new functions to you. > > pgstattuple module provides a `pgstatindex()`, and other small > functions, which allow you to get b-tree internal information. > I believe this module will be helpful to know b-tree index deeply. > > So please try it, send comment to me, and have fun. > > Thanks, > -- > NAGAYASU Satoshi <nagayasus@nttdata.co.jp> > > ----------------------------------------------------- > pgbench=# \x > Expanded display is on. > pgbench=# SELECT * FROM pgstatindex('accounts_pkey'); > -[ RECORD 1 ]------+-------- > version | 2 > tree_level | 1 > index_size | 3588096 > root_block_no | 3 > internal_pages | 0 > leaf_pages | 437 > empty_pages | 0 > deleted_pages | 0 > avg_leaf_density | 59.5 > leaf_fragmentation | 49.89 > ----------------------------------------------------- > > [ application/x-gzip is not supported, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
|
04-18-2008, 12:55 AM
| ||||
| ||||
| Re: pgstattuple extension for indexes Bruce, I'll fix it in this week. Please wait a few days. Thanks. Bruce Momjian wrote: > nagayasu-san, > > This looks good, but we would like the code added to > /contrib/pgstattuple, rather than it being its own /contrib module. Can > you make that adjustment? Thanks. > > --------------------------------------------------------------------------- > > satoshi nagayasu wrote: >> Hi folks, >> >> As I said on -PATCHES, I've been working on an utility to get >> a b-tree index information. I'm happy to introduce >> my new functions to you. >> >> pgstattuple module provides a `pgstatindex()`, and other small >> functions, which allow you to get b-tree internal information. >> I believe this module will be helpful to know b-tree index deeply. >> >> So please try it, send comment to me, and have fun. >> >> Thanks, >> -- >> NAGAYASU Satoshi <nagayasus@nttdata.co.jp> >> >> ----------------------------------------------------- >> pgbench=# \x >> Expanded display is on. >> pgbench=# SELECT * FROM pgstatindex('accounts_pkey'); >> -[ RECORD 1 ]------+-------- >> version | 2 >> tree_level | 1 >> index_size | 3588096 >> root_block_no | 3 >> internal_pages | 0 >> leaf_pages | 437 >> empty_pages | 0 >> deleted_pages | 0 >> avg_leaf_density | 59.5 >> leaf_fragmentation | 49.89 >> ----------------------------------------------------- >> >> > > [ application/x-gzip is not supported, skipping... ] > >> ---------------------------(end of broadcast)--------------------------- >> TIP 4: Have you searched our list archives? >> >> http://archives.postgresql.org > -- NAGAYASU Satoshi <nagayasus@nttdata.co.jp> Phone: +81-3-3523-8122 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
Linear Mode
