explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cKEvI

Settings
# exclusive inclusive rows x rows loops node
1. 1,419.657 1,421.949 ↑ 7,264.7 226 1

Seq Scan on tenants (cost=4.09..238,992.04 rows=1,641,812 width=4) (actual time=50.224..1,421.949 rows=226 loops=1)

  • Filter: ((deleted_at IS NULL) AND ((id = 2,906,683) OR (hashed SubPlan 1)))
  • Rows Removed by Filter: 3,053,683
  • Functions: 20
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 3.208 ms, Inlining 0.000 ms, Optimization 1.558 ms, Emission 23.748 ms, Total 28.514 ms
2.          

SubPlan (for Seq Scan)

3. 2.292 2.292 ↑ 1.0 1 1

Index Scan using tenants_pkey on tenants tenants_1 (cost=0.09..4.09 rows=1 width=16) (actual time=2.289..2.292 rows=1 loops=1)

  • Index Cond: (id = 2,906,683)
  • Filter: ((deleted_at IS NULL) AND (global_tenant_id IS NOT NULL))
Planning time : 0.199 ms
Execution time : 1,424.943 ms