Esta es una consulta simple para buscar schemas ó usuarios en una base de datos oracle SELECT * FROM dba_users WHERE username IN ('nombre_usuario');
In previous posts, we introduced you to Saby Explain, a public service for the analysis and visualization of PostgreSQL query plans. Several months after the launch we've reached the milestone of 6,000 usages, but one of the helpful features sometime...
After reading this article, you’ll learn about the techniques we use to analyze SQL query performance when dealing with millions of queries per day and monitoring hundreds of PostgreSQL servers. We’ll talk about Saby Explain, a tool that helps us han...
Cuando implementas PostgreSQL en un clúster de Amazon EKS (Elastic Kubernetes Service), puedes encontrarte con varios problemas relacionados con el almacenamiento y la recuperación de datos. Uno de los errores comunes es el siguiente: PostgreSQL Data...
In PostgreSQL, the architecture does not use threads for client connections but instead utilizes a multi-process model where each client connection is handled by an individual server process. This approach has implications for how performance and que...
In ClickHouse, the CAST operator is used to convert a value from one data type to another. This can be particularly useful in scenarios where you need to ensure that data types match between different parts of your queries, such as when comparing col...
Introduction In the world of database performance optimization, identifying and resolving performance bottlenecks is crucial. One common cause of slow query execution is the absence of proper indexes. In this blog post, we will explore the relationsh...
Introduction In the world of databases, PostgreSQL stands out as one of the most powerful and reliable open-source relational database management systems. It offers a wide range of features and functionalities, including a well-defined lifecycle for ...
Changing the data type of a column in ClickHouse, like in many database systems, is a sensitive operation and needs careful planning, especially in a production environment. Directly altering a column's data type isn't supported as a single operation...
Identifying and fixing bloated tables and indexes in PostgreSQL is crucial for maintaining database performance and efficient use of disk space. Bloat occurs due to PostgreSQL's MVCC (Multi-Version Concurrency Control) implementation, where old versi...
