Skip to content

Add reserved threads and 10 missing showplan XML attributes#378

Merged
erikdarlingdata merged 1 commit intodevfrom
feature/showplan-attributes-sync
Feb 28, 2026
Merged

Add reserved threads and 10 missing showplan XML attributes#378
erikdarlingdata merged 1 commit intodevfrom
feature/showplan-attributes-sync

Conversation

@erikdarlingdata
Copy link
Copy Markdown
Owner

Summary

  • Properties panel now shows Reserved Threads, Inactive Threads, and per-node reservation breakdown in Thread Stats section
  • Wait stats bar column uses fixed width (316px) instead of Star for proper duration text alignment
  • Added parsing and display for 10 missing showplan XML attributes identified by XSD audit:
    1. QueryPlan.MemoryGrant — top-level memory grant value
    2. GuessedSelectivity — flags optimizer selectivity guesses on predicates
    3. UnmatchedIndexes — unmatched index detail text
    4. ForeignKeyReferencesCount — foreign key reference check count
    5. NoMatchingIndexCount — no matching index count
    6. PartialMatchingIndexCount — partial matching index count
    7. ConstantScan.Values — actual row values in constant scans
    8. StmtUseDb.Database — database name from USE statements
    9. SpillOccurred.Detail — spill occurred boolean flag
    10. UDX.UsedUDXColumns — CLR aggregate columns

Changes synced from plan-b to both Dashboard and Lite (6 files, models + parser + properties display each).

Test plan

  • Build Dashboard and Lite with 0 errors
  • Open a plan with parallelism — verify Reserved/Inactive Threads appear in Thread Stats
  • Wait stats duration text aligned next to bars (not pushed to far right)
  • Open plans with various operators to verify new attribute display

🤖 Generated with Claude Code

Properties panel now shows Reserved Threads, Inactive Threads, and
per-node reservation breakdown in Thread Stats section. Wait stats bar
column uses fixed width instead of Star for proper duration alignment.
Added parsing and display for QueryPlan.MemoryGrant, GuessedSelectivity,
UnmatchedIndexes, ForeignKeyReferenceCheck counts, ConstantScan.Values,
StmtUseDb.Database, SpillOccurred.Detail, and UDX.UsedUDXColumns from
XSD audit. Changes synced from plan-b to both Dashboard and Lite.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit 0cad346 into dev Feb 28, 2026
3 checks passed
@erikdarlingdata erikdarlingdata deleted the feature/showplan-attributes-sync branch March 2, 2026 16:51
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant