8 dépôts
Diagnostic tools for analyzing database execution plans and server activity to optimize performance.
Distinct from SQL Query Optimizations: Shortlist contains optimizers and engines, but not diagnostic profiling tools for execution plan analysis.
Explore 8 awesome GitHub repositories matching data & databases · SQL Query Profilers. Refine with filters or upvote what's useful.
Azure Data Studio is a cross-platform SQL database management IDE used for writing queries, managing schemas, and administering relational databases. It functions as a comprehensive environment for relational database management, providing a structured interface for executing SQL queries and browsing database objects. The platform is distinguished by its interactive data notebooks, which combine executable code cells, narrative text, and visualizations for data analysis. It also includes specialized tools for database migration, allowing users to assess and transfer schemas and data from on-p
Provides a diagnostic profiler to analyze execution plans and server activity for query optimization.
jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f
Detects inefficient queries, duplicate statements, and unnecessary column projections by proxying JDBC connections.
Perfetto is a platform for system-level performance tracing and analysis on Linux and Android. It combines a high-throughput trace recorder, a SQL-based query engine, and a browser-based visualizer into a single toolchain. The platform covers CPU scheduling and call-stack profiling, native and Java heap memory allocation tracking, GPU and graphics events, and system-wide counters such as CPU frequency and power consumption. The architecture decouples trace recording from offline analysis, using a compact protobuf format for event encoding and columnar storage for efficient SQL queries. The we
Analyzes heap profile data using SQL queries against tables of call stacks and allocations.
Telescope est un tableau de bord de débogage et un outil de développement pour les applications Laravel qui fournit une interface web pour surveiller les requêtes, les exceptions, les requêtes de base de données et les logs. Il fonctionne comme un moniteur d'application PHP et un assistant de diagnostic, retraçant le cycle de vie d'exécution du système pour identifier et résoudre les bugs. L'outil se distingue en offrant des profileurs spécialisés pour les requêtes SQL et les commandes Redis, ainsi qu'un système de prévisualisation dans le navigateur pour les e-mails sortants. Il inclut également un système d'audit dédié pour les commandes console et les vérifications de portes d'autorisation afin de vérifier la logique des permissions. La plateforme couvre un large éventail de domaines d'observabilité, notamment le suivi des tâches et processus en arrière-plan, l'inspection des opérations de cache et la surveillance des événements d'application. Elle analyse le cycle de vie des requêtes via les données d'en-tête et de session, enregistre les traces de pile complètes pour les exceptions et surveille le rendu des vues et l'hydratation des modèles. L'accès à l'interface de surveillance est géré via une porte d'autorisation centralisée.
Logs raw SQL execution times and bindings to identify and resolve slow database queries.
Django Silk is a profiling and inspection toolset for Django applications designed to capture SQL queries, HTTP request data, and execution timing for diagnostics. It functions as a performance profiler and debugging middleware that records runtime execution data to provide a comprehensive overview of application behavior. The system includes a database profiler for identifying slow operations through detailed timing data and an HTTP request inspector for reviewing headers, bodies, and network traffic via a web interface. It allows for the reproduction of specific server requests through gene
Analyzes every SQL query executed during a Django request, showing execution time, tables, joins, and stack traces.
Baserow is a self-hosted, no-code relational database platform built on PostgreSQL. It provides a spreadsheet-like interface for structuring and managing data without writing code, while exposing all database resources via a REST API to support headless architectures. The platform distinguishes itself by integrating large language models and embedding servers to power AI assistants and automated data generation. It further extends its utility as a no-code application builder, allowing users to create custom internal portals, dashboards, and business tools using visual logic and managed data.
Inspects executed requests and database queries in real-time to analyze performance.
This project is a collection of specialized toolsets for SQL Server, functioning as a diagnostic toolkit, performance monitor, and database administrator framework. It provides stored procedures and utilities designed to automate backup recovery, diagnose system health, and optimize database performance and indexing. The kit distinguishes itself through specialized capabilities for point-in-time restoration and the calculation of estimated data loss windows using backup history. It also includes an index optimizer that analyzes usage and size to provide prioritized recommendations for data re
Compares execution plans and analyzes deadlock events to troubleshoot complex database performance issues.
FalkorDB is a high-performance graph database management system and vector graph database. It serves as a knowledge graph construction tool and a GraphRAG knowledge store, integrating structured property graphs with vector search to provide grounded context for large language models. The engine is designed as a multi-tenant graph engine, capable of hosting thousands of isolated datasets within a single instance. The system distinguishes itself by using linear algebra for query execution, treating relationship tensors as matrix multiplications to achieve low-latency multi-hop traversals. It ut
Includes diagnostic tools for analyzing execution plans to identify missing indexes and optimize query performance.