explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1F67

Settings
# exclusive inclusive rows x rows loops node
1. 2,518.877 2,521.173 ↑ 130.2 12,612 1

Index Only Scan using index_tenants_on_account_id_and_id_and_deleted_at on tenants (cost=4.18..105,452.41 rows=1,641,812 width=4) (actual time=1,854.141..2,521.173 rows=12,612 loops=1)

  • Index Cond: (deleted_at IS NULL)
  • Filter: ((id = 2,906,683) OR (hashed SubPlan 1))
  • Rows Removed by Filter: 2,687,201
  • Heap Fetches: 2,698,956
  • Functions: 17
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 1.907 ms, Inlining 0.000 ms, Optimization 0.625 ms, Emission 10.654 ms, Total 13.187 ms
2.          

SubPlan (for Index Only Scan)

3. 2.296 2.296 ↑ 1.0 1 1

Index Scan using tenants_pkey on tenants tenants_1 (cost=0.09..4.09 rows=1 width=4) (actual time=2.293..2.296 rows=1 loops=1)

  • Index Cond: (id = 2,906,683)
  • Filter: (deleted_at IS NULL)
Planning time : 0.229 ms
Execution time : 2,523.463 ms