citusdata / citusdata/citus

Distributed EXPLAIN: Phase 3 - Complex queries

Open
#121 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

In phase 1-2, we only addressed simple queries without MapMerge Jobs. In this phase we nest EXPLAIN plans for nested jobs into the EXPLAIN plans of their parents. This requires more consideration of how to set up temporary tables and how to correctly implement the nesting.

Contributor guide

Open the contributing guide

Research direction

Start by reviewing how distributed EXPLAIN handles the phase 1–2 simple-query cases and MapMerge Jobs. Investigate how temporary tables should be set up for nested jobs, and consider the work complete when nested EXPLAIN plans are correctly included in their parent plans.

Written by the indexing model from the issue text.

Assessment

Tech stack
c, postgresql
Domain
databases, distributed-systems
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.