/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 postgrespro.com
Queries in PostgreSQL: 4. Index scan : Postgres Professional
| | www.sagargv.com
How to read a query plan from Postgres EXPLAIN
2.7 parsecs away

Travel
| |
| | use-the-index-luke.com
Index INCLUDE Clause: How it works and when to use it
2.9 parsecs away

Travel
| | The INCLUDE clause for CREATE INDEX is available in some SQL databases: Microsoft SQL Server, PostgreSQL, and IBM Db2 (LUW)
| | boringsql.com
Production query plans without production data | boringSQL
3.9 parsecs away

Travel
| | PostgreSQL 18 makes optimizer statistics portable. Export them from production and inject them into test databases to get realistic query plans without the data.
| | timilearning.com
Data Storage on Your Computer's Disk - Part 1
23.6 parsecs away

Travel
| Have you ever wondered how data stored in databases actually gets represented on your computer's hard disk? Or why some queries to your database tables benefit from adding indexes on columns? Well, whether you have or not, here's a series of posts that aim to detail my understanding of the journey from inserting a row to a database table, to actually retrieving that row.