explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HJf6

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.85..637.99 rows=11,346 width=4) (actual time=0.009..0.009 rows=0 loops=1)

2. 0.008 0.008 ↓ 0.0 0 1

Index Scan using connections_tenant_name_name on connections (cost=0.29..8.30 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (((tenant_name)::text = 'bar'::text) AND ((name)::text = 'pepe'::text))
3. 0.000 0.000 ↓ 0.0 0

Index Only Scan using connections_clients_pkey on connections_clients (cost=0.57..534.73 rows=9,495 width=8) (never executed)

  • Index Cond: (id_connection = connections.id)
  • Heap Fetches: 0