Row count for all tables in a postgres database

100%

Row count for all tables in a postgres database

✓ Published0🌍 Public

Last edited Apr 4, 2017

Created on Apr 4, 2017

This visualization ranks every table in a PostgreSQL database by its live row count, displaying the table names and schemas in descending order. The horizontal bar chart makes it immediately clear which tables dominate the database in size and how quickly the counts taper off. The data comes from the `pg_stat_user_tables` system view, which tracks `n_live_tup` (an estimate of live rows). The query runs directly against PostgreSQL, returning `schemaname`, `relname`, and `n_live_tup` for each table, and the chart renders those values as proportional bars.

AI-generated description

Similar vizzes

Loading thumbnail…

Postgres is Enough

The visualization maps PostgreSQL’s ecosystem onto a network graph, showing how the database extends into background jobs, search, APIs, and data visualization. It uses a force-directed layout with `d3.forceSimulation` to position nodes representing tools like pg_cron, PostGIS, pgvector, and Metabase, while links connect related categories. The graph is rendered as an SVG with D3’s `d3.select` and `d3.line`, with node sizes encoding the number of associated libraries. Data comes from the static markdown file listing each tool’s URL and category.

Aapburnes

62% match

Loading thumbnail…

List schema and tables from all databases in PostgreSQL cluster

This example shows a two-step pipeline that first lists every database in a PostgreSQL cluster and then aggregates all user-defined schemas and tables from each database into a single CSV file. The first `psql` query retrieves database names, excluding `template0`, and writes them to `databases.txt`. A shell loop then runs a second `psql` query against each database, selecting `schemaname` and `tablename` while filtering out system schemas, and appends results with the database name to `all_tables.txt`. The code uses the PostgreSQL command-line client with `-t --csv` flags to output tab-separated CSV data.

TThomasG77

59% match

Loading thumbnail…

Get Table Sizes (in MB) for a database

This visualization shows the size of each table in a MySQL database in megabytes, sorted from largest to smallest. It displays the table names alongside their computed sizes using a bar chart or similar comparison layout. The SQL query in `get_table_size.sql` calculates each table’s total size by summing `data_length` and `index_length` from the `information_schema.TABLES` metadata, then divides by 1024 twice and rounds to two decimal places. The query orders results by size in descending order, and the visualization renders this data as its primary output.

WWilliamQLiu

59% match

Loading thumbnail…

PostgreSQL command line cheatsheet

This example presents a text-based cheat sheet for PostgreSQL command-line tools, rendering a curated list of psql commands, configuration snippets, and handy SQL queries in a plain markdown document. It shows the core syntax for database management tasks, such as connecting to databases, listing tables and views, managing user roles, and adjusting server logging verbosity, alongside query examples for inspecting indexes, active sessions, and table sizes. The visualization relies on static code blocks and inline formatting, with no interactive graphics or JavaScript libraries; instead, it leverages the raw text content from a gist, emphasizing practical API references like `psql` meta-commands and `pg_stat_activity` queries.

AAngieLiang

57% match

Loading thumbnail…

Gist 860389

This example visualizes the schema of a phpBB posts database table, showing its columns, data types, and indexing structure. It uses a custom layout to represent each field as a node, with primary key and foreign key relationships highlighted through color and grouping. The visualization is rendered using D3.js, likely with `d3.forceSimulation` or a similar layout algorithm, and the underlying data is read directly from the SQL `CREATE TABLE` statement in the gist file. The code parses the schema definitions to generate the graph, mapping attributes like keys and full-text indexes visually.

TTBD

54% match

Loading thumbnail…

circle packing using d3 pack layout

This example shows database rankings as a circle packing visualization, where each database name is rendered inside a circle sized according to its ranking score. The circles are arranged hierarchically via the D3 `d3.layout.pack` layout, with SVG circles and text labels styled using the Rock Salt font. The chart is built with D3 version 3.5.6, using the `pack.nodes` method to compute positions and radii, and mouseover/mouseout events change the circle stroke from grey to black. The data consists of seven databases like PostgreSQL and mongoDB, each with a numeric size value.

Aaaizemberg

54% match

Loading thumbnail…

find long running query in postgres

This example displays PostgreSQL processes that have been running for more than five minutes, highlighting long-running queries for database monitoring. It uses a SQL query against `pg_stat_activity` to retrieve process IDs, query text, waiting status, wait reasons, and start times, filtering out idle sessions and ordering by duration. The visualization presents these results as a text-based table or list, with the data sourced directly from the live database system catalog. The code relies on standard PostgreSQL system functions like `now()` and interval comparisons to identify and rank the most time-consuming queries.

Aadkdev

54% match

Loading thumbnail…

Connexion à PostgreSQL + histogramme avec ggplot2

This example demonstrates how to create a histogram directly from a PostgreSQL database table using R. The code first establishes a database connection with the `DBI` and `RPostgreSQL` packages, then uses `dplyr` and `dbplyr` to query the table as a remote data frame. The `ggplot2` library renders the histogram via `geom_histogram`, mapping a specified column to the aesthetic. Finally, the connection is explicitly closed with `dbDisconnect`. The code illustrates a workflow for plotting distributed data without loading it entirely into local memory.

RRCura

54% match