Internal Name:

Table

Description:

Database table

Singleton:

no

Plugin:

Postgres

Table Name

yes

tableName

Sequential Scans

measurement

Number of sequential scans done against this table (when an index scan was not possible)

seq_scan

Sequential Scans per Minute

measurement

Number of sequential scans done against this table (when an index scan was not possible)

seq_scan

Sequential Rows Read

measurement

Number of rows read by sequential scans

seq_tup_read

Sequential Rows Read per Minute

measurement

Number of rows read by sequential scans

seq_tup_read

Index Scans

measurement

Number of index scans done against this table

idx_scan

Index Scans per Minute

measurement

Number of index scans done against this table

idx_scan

Index Scan Rows Read

measurement

Number of index entries returned by index scans

idx_tup_fetch

Index Scan Rows Read per Minute

measurement

Number of index entries returned by index scans

idx_tup_fetch

Heap Blocks Read

measurement

The number of heap blocks read that were not a buffer cache hit

heap_blks_read

Heap Blocks Read per Minute

measurement

The number of heap blocks read that were not a buffer cache hit

heap_blks_read

Heap Blocks Hit

measurement

The number of heap block requests that were found in the buffer cache

heap_blks_hit

Heap Blocks Hit per Minute

measurement

The number of heap block requests that were found in the buffer cache

heap_blks_hit

Index Blocks Read

measurement

The number of index blocks fetched that were not a buffer cache hit

idx_blks_read

Index Blocks Read per Minute

measurement

The number of index blocks fetched that were not a buffer cache hit

idx_blks_read

Index Blocks Hit

measurement

The number of index block requests that were found in the buffer cache

idx_blks_hit

Index Blocks Hit per Minute

measurement

The number of index block requests that were found in the buffer cache

idx_blks_hit

Toast Blocks Reads

measurement

The number of toast blocks fetched that were not a buffer cache hit

toast_blks_read

Toast Blocks Reads per Minute

measurement

The number of toast blocks fetched that were not a buffer cache hit

toast_blks_read

Toast Blocks Hit

measurement

The number of toast block requests that were found in the buffer cache

toast_blks_hit

Toast Blocks Hit per Minute

measurement

The number of toast block requests that were found in the buffer cache

toast_blks_hit

Toast Index Blocks Read

measurement

The number of toast index blocks fetched that were not a buffer cache hit

tidx_blks_read

Toast Index Blocks Read per Minute

measurement

The number of toast index blocks fetched that were not a buffer cache hit

tidx_blks_read

Toast Index Blocks Hit

measurement

The number of toast index block requests that were found in the buffer cache

tidx_blks_hit

Toast Index Blocks Hit per Minute

measurement

The number of toast index block requests that were found in the buffer cache

tidx_blks_hit

Row Inserts

measurement

The number of rows ever inserted into this table

n_tup_ins

Row Inserts per Minute

measurement

The number of rows ever inserted into this table

n_tup_ins

Row Updates

measurement

The number of rows ever updated on this table

n_tup_upd

Row Updates per Minute

measurement

The number of rows ever updated on this table

n_tup_upd

Row Deletes

measurement

The number of rows ever deleted from this table

n_tup_del

Row Deletes per Minute

measurement

The number of rows ever deleted from this table

n_tup_del

Table Size

measurement

The size in bytes of the data in the table

table_size

Total Size

measurement

The size in bytes of the data and all associated indexes and toast tables

total_size

Rows

measurement

The count of rows in the table. Warning: This may be an expensive operation

rows

Approximate rows

measurement

The approximate count of rows in the table. This is basically the number of rows of the last ANALYZE of the table. This metric is not expensive.

rows_approx

Table Name

yes

tableName

Columns

yes

columns

Vacuum

Vacuum the table