GP - How to check bloated tables

How do I check for tables which are bloated?

select bdinspname as "Schema", bdirelname as "Table", bdidiag "Bloat Diagnosis" from gp_toolkit.gp_bloat_diag order by 1,2 desc

Location: Bengaluru, Karnataka, India

Comments

Post a Comment

Popular posts from this blog

GP - SQL to fetch table(s) owned by given user

SQL SELECT n.nspname||'.'||c.relname FROM pg_catalog.pg_class As c INNER JOIN pg_catalog.pg_namespace AS n ON c.relnamespace = n.oid AND n.nspname = '<schemaname>' AND  c.relkind IN ('r','v') AND c.relstorage != 'x' INNER JOIN pg_catalog.pg_roles AS r ON c.relowner = r.oid AND r.rolname = '<userid>' EXCEPT SELECT partitionschemaname||'.'||partitiontablename FROM pg_catalog.pg_partitions ORDER BY 1; Here <schemaname> and  <userid> can be supplied accordingly to fetch details.
Read more

The Segment - Brief

Image
The Segments In Greenplum Database, the segments are where data is stored and where most query processing occurs. User-defined tables and their indexes are distributed across the available segments in the Greenplum Database system; each segment contains a distinct portion of the data. Segment instances are the database server processes that serve segments. Users do not interact directly with the segments in a Greenplum Database system, but do so through the master. In the reference Greenplum Database hardware configurations, the number of segment instances per segment host is determined by the number of effective CPUs or CPU core. For example, if your segment hosts have two dual-core processors, you may have two or four primary segments per host. If your segment hosts have three quad-core processors, you may have three, six or twelve segments per host. Performance testing will help decide the best number of segments for a chosen hardware platform. Segment Redundancy When ...
Read more

What is Data Acquisition?

Data acquisition systems, as the name implies, are products and/or processes used to collect information to document or analyze some phenomenon. In the simplest form, a technician logging the temperature of an oven on a piece of paper is performing data acquisition. As technology has progressed, this type of process has been simplified and made more accurate, versatile, and reliable through electronic equipment. Equipment ranges from simple recorders to sophisticated computer systems. Data acquisition products serve as a focal point in a system, tying together a wide variety of products, such as sensors  that indicate temperature, flow, level, or pressure. Data acquisition systems typically convert analog Physical condition into digital values for easy processing. Parts of a DAQ System Sensor DAQ Device Computer What Is a Sensor? The measurement of a physical phenomenon, such as the temperature of a room, the intensity of a light source, or the force applie...
Read more