Database query performance laboratory
An educational workbench for comparing query plans, indexes and execution behaviour using reproducible database workloads.
Project brief
Project scope
Project components, tools, requirements, testing, and limitations will be added when this project is scoped.
Current scopeAdvanced
The project tools will be confirmed during scoping.
Included
- 01PostgreSQL 18.6 laboratory with a deterministic four-table commerce dataset and pinned Docker environment
- 02Bounded Python runner for read-only EXPLAIN ANALYZE JSON experiments
- 03Structured plan-tree parser with timing, row-estimate, buffer, and temporary I/O evidence
- 0495 retained runs across scan, index, join, sort-memory, scaling, and extended-statistics experiments
- 05Responsive loopback-only result viewer and eight reproducible project figures
- 0612 automated tests with clean lint, dependency audit, document accessibility, and repository checks
- 07Complete source code in a private GitHub repository
- 0880-page project documentation in PDF and editable Word formats
- 0910-page setup and usage guide in PDF and editable Word formats
Project record
No information is collected on this page.
- Permanent project ID
- GP-CS-1S7MWF3
- Catalogued
- 21 Aug 2026
- Completed
- 23 Aug 2026
- Verified
- 23 Aug 2026
- Demonstration
- Included in repository
Handover
After purchase
- 01Payment is confirmed
The project is marked unavailable and cannot be purchased again.
- 02Repository access is granted
The buyer's submitted GitHub account receives access to the private repository.
- 03The purchase record is delivered
The certification sheet is prepared from the reviewed buyer details and sent privately by email.