explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aixn

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

Index Only Scan using index_tenants_on_account_id_and_id_and_deleted_at on tenants (cost=0.09..105,448.32 rows=1,641,812 width=4) (actual time=1,824.600..2,486.265 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: 12
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 1.246 ms, Inlining 0.000 ms, Optimization 0.372 ms, Emission 6.665 ms, Total 8.282 ms
2.          

SubPlan (for Index Only Scan)

3. 2.261 2.261 ↑ 1.0 1 1

Result (cost=0.00..0.00 rows=1 width=4) (actual time=2.261..2.261 rows=1 loops=1)

Planning time : 0.136 ms
Execution time : 2,487.921 ms