explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L7xb

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.135 ↓ 4.0 4 1

Hash Join (cost=12.75..44.86 rows=1 width=3,884) (actual time=0.105..0.135 rows=4 loops=1)

  • Hash Cond: (job_offer.branch_id = branch.id)
  • 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)) 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))
2. 0.003 0.111 ↑ 1.0 4 1

Nested Loop (cost=0.53..32.63 rows=4 width=6,028) (actual time=0.083..0.111 rows=4 loops=1)

3. 0.000 0.060 ↓ 12.0 12 1

Nested Loop (cost=0.40..24.48 rows=1 width=2,160) (actual time=0.033..0.060 rows=12 loops=1)

4. 0.024 0.024 ↓ 12.0 12 1

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.019..0.024 rows=12 loops=1)

5. 0.000 0.036 ↑ 1.0 1 12

Nested Loop Left Join (cost=0.28..16.32 rows=1 width=80) (actual time=0.002..0.003 rows=1 loops=12)

  • Join Filter: (login_access.login_id = login.id)
6. 0.024 0.024 ↑ 1.0 1 12

Index Scan using login_pkey on login (cost=0.13..8.14 rows=1 width=32) (actual time=0.001..0.002 rows=1 loops=12)

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

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

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

Index Scan using job_offer_job_offer_address_id_idx on job_offer (cost=0.13..8.15 rows=1 width=3,884) (actual time=0.004..0.004 rows=0 loops=12)

  • Index Cond: (job_offer_address_id = jo_address.id)
9. 0.003 0.010 ↑ 1.0 3 1

Hash (cost=12.18..12.18 rows=3 width=32) (actual time=0.010..0.010 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.007 0.007 ↑ 1.0 3 1

Index Scan using branch_pkey on branch (cost=0.13..12.18 rows=3 width=32) (actual time=0.005..0.007 rows=3 loops=1)