Products
Time series and analytics
PostgreSQL but faster. Built for lightning-fast ingest and querying of time-based and event data.
Time series and analyticsAI and Vector
PostgreSQL for AI. Seamlessly build RAG, search, and AI agents with the pgvector, pgvectorscale, and pgai extensions.
AI and VectorDeployment options & services
Support Services
Support options to adapt to your use case, infrastructure, and budget.
Open-Source Extensions and Tools
Open-source PostgreSQL extensions you can run on your own instances.
Security scanner
pgspot
We’re in your corner even during the trial phase. Contact us to discuss your use case with a Timescale technical expert.
Timescale is PostgreSQL made Powerful
Industries that rely on us
Featured articles
PostgreSQL for Industrial IoT Data
How OpenSauced Is Building a Copilot for Git History With pgvector and Timescale
AI and Vector
PostgreSQL for AI. Seamlessly build RAG, search, and AI agents with the pgvector, pgvectorscale, and pgai extensions.
pgai docspgvector docsAI and VectorLearn PostgreSQL
Timescale is PostgreSQL, but faster. Learn the PostgreSQL basics and scale your database performance to new heights
Subscribe to the Timescale Newsletter
By submitting, you acknowledge Timescale’s Privacy Policy
By submitting, you acknowledge Timescale’s Privacy Policy
\d TABLE_NAME
// Show table definition including indexes, constraints & triggers (psql)
\d+ TABLE_NAME
// More detailed table definition including description and physical disk size (psql)
\dt
// List tables from current schema (psql)
\dt *.*
// List tables from all schemas (psql)
\dt <name-of-schema>.*
// List the tables in a specific schema (psql)
\copy (SELECT * FROM __table_name__) TO 'file_path_and_name.csv' WITH CSV
// Export a table as CSV (psql)
SELECT * FROM pg_indexes WHERE tablename='__table_name__' AND
schemaname='__schema_name__';
// Show table indexes (SQL)
ANALYZE [__table__]
// Analyze a table and store the results in the pg_statistic system catalog (SQL)
With no parameter, ANALYZE
examines every table in the current database
Comment on table employee is 'Stores employee records';
// Comment on table (SQL)
Comment on column employee.ssn is 'Employee Social Security Number';
// Comment on column (SQL)
SELECT reltuples AS card FROM pg_class WHERE relname = '<table_name>';
// Use this to do fast (but not exact) counts from tables. Helpful if a table has millions/billions of records and you just want estimated rows quickly. (SQL)