explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r3jU

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.014 ↑ 1.0 1 1

Nested Loop (cost=0.71..16.74 rows=1 width=63) (actual time=0.014..0.014 rows=1 loops=1)

2. 0.008 0.008 ↑ 1.0 1 1

Index Scan using "IDX_USERS_ID_ISDELETED" on users "User" (cost=0.42..8.44 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = '173c0ee3-ea8c-43c6-afa8-82d81b10e8d2'::uuid)
3. 0.004 0.004 ↑ 1.0 1 1

Index Scan using "PK_53be67a04681c66b87ee27c9321" on tenants "Tenant" (cost=0.29..8.30 rows=1 width=63) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (id = "User"."tenantId")
Planning time : 0.359 ms
Execution time : 0.034 ms