explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ynI

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 0.026 ↑ 1.0 10 1

Limit (cost=0.00..0.38 rows=10 width=182) (actual time=0.011..0.026 rows=10 loops=1)

  • Output: user_id, lead_id, profile_date, credit_score, phone_home, email_id, first_name, last_name, referral_code, tkn, employment_type, monthly_income, salary_account, age, city, pincode, customer_profile_id
  • Buffers: shared hit=1
2. 0.014 0.014 ↑ 338,644.0 10 1

Seq Scan on test.hdb_green (cost=0.00..127,579.40 rows=3,386,440 width=182) (actual time=0.009..0.014 rows=10 loops=1)

  • Output: user_id, lead_id, profile_date, credit_score, phone_home, email_id, first_name, last_name, referral_code, tkn, employment_type, monthly_income, salary_account, age, city, pincode, customer_profile_id
  • Buffers: shared hit=1