✍️
Today IL
  • Today I learned!
  • Deployment
    • Rolling, Canary, Blue-green deployments
    • Kubernetees Helm Charts
  • AI/ML
    • SeldonIO
    • Installing software in E2E cloud compute
    • Watching nvidia-smi
    • How does github copilot works?
    • composer library
    • Better to pass callback in fit_one_cycle
    • Eliza - demo
    • Helsinki-NLP Translation models
  • Fastai Learning
  • Python
    • Understanding get_image_files in fastai
    • Resizing an image to smaller size
    • Extracting a Json Object as List(regex)
    • f-strings debugging shortcut
    • Pytest
    • conda switch between python versions
    • Nested functions exception handling
  • Programming
    • Installing Linux Operating system
    • Certbots usage
    • Code highlighting in Google Docs
    • HTTP Methods
    • How to use vertical mouse?
    • HTTP Status Codes
    • Keycloak, Oauth, OpenID connect, SAML
    • Why should NPM packages be as small as possible?
    • Clean Architecture
    • REST vs gRPC
    • Keycloak concepts
    • what is proxy server and nginx?
    • Asymptotic Time Complexity
  • async/await
    • JavaScript Asynchronous operation
    • Lesson 2- Eventloops
    • Lesson 1- asyncio history
    • Lesson 3- using coroutines
    • Lesson 4- coroutines in hood
    • Python async/await
    • JavaScript
  • R Programming language
    • Facet_grid and Facet_wrap
    • geom_point
  • C programming language
    • Inputting String in C programming language
    • Checking if a element is passed as input or not?
  • Git/Github
    • give credits to other people
    • one time setting to easily use Github
    • Checkout to specific tag
    • git suggestions in PR
    • Using emojis in git commits
  • Databases
    • Postgres Database Dockercompose
    • TIL New SQL Operators - Except, UNION, Distinct
    • Analysing Performance of DB Queries
    • Querying Date ranges in postgres
    • Handling Database disconnects in SQLAlchemy
  • WITH NO EXCEPT
  • What is difference with JSON documents in postgres and Mongodb
Powered by GitBook
On this page
  • PostgreSQL
  • MongoDB

Was this helpful?

  1. Databases

Analysing Performance of DB Queries

PreviousTIL New SQL Operators - Except, UNION, DistinctNextQuerying Date ranges in postgres

Last updated 3 years ago

Was this helpful?

How can you understand if your Database queries are actually being indexed or not and how efficiently they are searching?

PostgreSQL

Let's look at how we can analyze the queries in PostgreSQL:

explain analyze select id, name from employees where id = 12

MongoDB

In case of mongodb as well there is an explain after collection name which you can use to understand the query performance:

You can use the cursor.explain() method or the db.collection.explain() method to determine whether or not a query uses an index. On using explain in mongodb queries you can notice that in case of query which requires full search will be in COLLSCAN status.

Now in case of efficient searching with indexes, it will be in the stage: IXSCAN

References

Find Out if a Query uses an Index in MongoDBDatabase.Guide
Logo