explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r7Q

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

Limit (cost=0.57..0.68 rows=1 width=8) (actual time=1.471..1.471 rows=0 loops=1)

2. 0.001 1.470 ↓ 0.0 0 1

Nested Loop (cost=0.57..1,252.66 rows=11,346 width=8) (actual time=1.470..1.470 rows=0 loops=1)

3. 1.469 1.469 ↓ 0.0 0 1

Seq Scan on connections conn (cost=0.00..622.98 rows=1 width=8) (actual time=1.469..1.469 rows=0 loops=1)

  • Filter: (((name)::text = 'pepe'::text) AND ((tenant_name)::text = 'bar'::text))
  • Rows Removed by Filter: 10,002
4. 0.000 0.000 ↓ 0.0 0

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

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