explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mjAZ

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

Nested Loop (cost=10,000,000,000.56..10,000,000,033.79 rows=1 width=3,884) (actual time=0.059..0.059 rows=0 loops=1)

2. 0.000 0.058 ↓ 0.0 0 1

Nested Loop (cost=10,000,000,000.42..10,000,000,025.63 rows=1 width=3,900) (actual time=0.058..0.058 rows=0 loops=1)

  • Join Filter: (branch.tenant_id = ANY (login_access.tenant_ids))
3. 0.004 0.054 ↓ 4.0 4 1

Nested Loop (cost=10,000,000,000.27..10,000,000,017.44 rows=1 width=3,900) (actual time=0.041..0.054 rows=4 loops=1)

4. 0.007 0.042 ↓ 4.0 4 1

Nested Loop (cost=10,000,000,000.12..10,000,000,009.15 rows=1 width=3,884) (actual time=0.032..0.042 rows=4 loops=1)

  • Join Filter: (job_offer.job_offer_address_id = jo_address.id)
  • Rows Removed by Join Filter: 24
5. 0.015 0.015 ↓ 4.0 4 1

Seq Scan on job_offer (cost=10,000,000,000.00..10,000,000,001.00 rows=1 width=3,884) (actual time=0.013..0.015 rows=4 loops=1)

6. 0.020 0.020 ↓ 7.0 7 4

Index Only Scan using job_offer_address_pkey on job_offer_address jo_address (cost=0.12..8.14 rows=1 width=16) (actual time=0.004..0.005 rows=7 loops=4)

  • Heap Fetches: 28
7. 0.008 0.008 ↑ 1.0 1 4

Index Scan using branch_pkey on branch (cost=0.14..8.16 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=4)

  • Index Cond: (id = job_offer.branch_id)
8. 0.004 0.004 ↓ 0.0 0 4

Index Scan using login_access_pkey on login_access (cost=0.15..8.17 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (login_id = 'bbf26ade-2515-4203-9ce7-f707317c8dc7'::uuid)
9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using login_pkey on login (cost=0.14..8.15 rows=1 width=16) (never executed)

  • Index Cond: (id = 'bbf26ade-2515-4203-9ce7-f707317c8dc7'::uuid)
  • Heap Fetches: 0