explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lkEV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=436,680.87..436,692.54 rows=100 width=4,691) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=436,680.87..440,351.00 rows=31,456 width=4,691) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=435,680.85..435,720.17 rows=15,728 width=4,691) (actual rows= loops=)

  • Sort Key: users_bluevineuser.created DESC
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=160,206.47..435,079.74 rows=15,728 width=4,691) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=160,206.05..425,136.70 rows=15,728 width=4,318) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=160,205.62..398,993.67 rows=15,728 width=1,616) (actual rows= loops=)

  • Hash Cond: (users_bluevineuser.id = users_bluevineusersettings.user_id)
  • Filter: ((upper((users_bluevineuser.id)::text) ~~ '%DUDA%'::text) OR (upper((users_bluevineuser.email)::text) ~~ '%DUDA%'::text) OR (upper(users_bluevineusersettings.business_name) ~~ '%DUDA%'::text) OR (upper(users_bluevineusersettings.personal_user_full_name) ~~ '%DUDA%'::text) OR (upper(users_bluevineusersettings.personal_authorised_person_full_name) ~~ '%DUDA%'::text))
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on users_bluevineuser (cost=0.00..119,991.22 rows=399,553 width=770) (actual rows= loops=)

  • Filter: ((company_id IS NULL) AND (NOT is_test))
8. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=115,832.50..115,832.50 rows=373,050 width=846) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on users_bluevineusersettings (cost=0.00..115,832.50 rows=373,050 width=846) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using users_bluevineusersecuresettings_user_id_key on users_bluevineusersecuresettings (cost=0.42..1.66 rows=1 width=2,702) (actual rows= loops=)

  • Index Cond: (users_bluevineuser.id = user_id)
11. 0.000 0.000 ↓ 0.0

Index Scan using users_bluevineusertermsandlegal_user_id_key on users_bluevineusertermsandlegal (cost=0.42..0.63 rows=1 width=373) (actual rows= loops=)

  • Index Cond: (users_bluevineuser.id = user_id)