explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RWUL

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.281 ↓ 4.0 4 1

Nested Loop (cost=10,000,000,000.56..10,000,000,034.48 rows=1 width=3,884) (actual time=0.193..0.281 rows=4 loops=1)

  • Join Filter: ((login.branch_id = job_offer.branch_id) OR (job_offer.branch_id = ANY (login_access.branch_ids)) OR (branch.tenant_id = ANY (login_access.tenant_ids)))
2. 0.154 0.255 ↓ 4.0 4 1

Nested Loop (cost=10,000,000,000.41..10,000,000,026.28 rows=1 width=3,964) (actual time=0.178..0.255 rows=4 loops=1)

  • Join Filter: ((job_offer.job_offer_address_id = jo_address.id) AND ((immutable_array_to_str(job_offer.skills) %> 'string'::text) OR (immutable_array_to_str(job_offer.tasks) %> 'string'::text) OR (immutable_array_to_str(job_offer.our_offers) %> 'string'::text) OR ((job_offer.top_text)::text %> 'string'::text) OR (job_offer.bottom_text %> 'string'::text) OR ((job_offer.profession)::text %> 'string'::text) OR ((job_offer.industry)::text %> 'string'::text) OR ((job_offer.job_offer_title)::text %> 'string'::text) OR ((jo_address.city)::text %> 'string'::text) OR ((jo_address.street)::text %> 'string'::text) OR ((jo_address.contact_person)::text %> 'string'::text) OR ((jo_address.firm_name)::text %> 'string'::text)))
  • Rows Removed by Join Filter: 24
3. 0.003 0.073 ↓ 4.0 4 1

Nested Loop Left Join (cost=10,000,000,000.28..10,000,000,017.34 rows=1 width=3,964) (actual time=0.047..0.073 rows=4 loops=1)

  • Join Filter: (login_access.login_id = login.id)
4. 0.009 0.062 ↓ 4.0 4 1

Nested Loop (cost=10,000,000,000.14..10,000,000,009.16 rows=1 width=3,916) (actual time=0.041..0.062 rows=4 loops=1)

5. 0.025 0.025 ↓ 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.020..0.025 rows=4 loops=1)

6. 0.028 0.028 ↑ 1.0 1 4

Index Scan using login_pkey on login (cost=0.14..8.15 rows=1 width=32) (actual time=0.006..0.007 rows=1 loops=4)

  • Index Cond: (id = 'bbf26ade-2515-4203-9ce7-f707317c8dc7'::uuid)
7. 0.008 0.008 ↓ 0.0 0 4

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

  • Index Cond: (login_id = 'bbf26ade-2515-4203-9ce7-f707317c8dc7'::uuid)
8. 0.028 0.028 ↓ 7.0 7 4

Index Scan using job_offer_address_pkey on job_offer_address jo_address (cost=0.12..8.14 rows=1 width=2,080) (actual time=0.003..0.007 rows=7 loops=4)

9. 0.016 0.016 ↑ 1.0 1 4

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

  • Index Cond: (id = job_offer.branch_id)