explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nxLZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,764.096 ↑ 3.8 26 1

Limit (cost=436,680.87..436,692.54 rows=100 width=4,691) (actual time=2,764.082..2,764.096 rows=26 loops=1)

2. 302.558 3,051.750 ↑ 1,209.8 26 1

Gather Merge (cost=436,680.87..440,351.00 rows=31,456 width=4,691) (actual time=2,764.081..3,051.750 rows=26 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.216 2,749.192 ↑ 1,747.6 9 3 / 3

Sort (cost=435,680.85..435,720.17 rows=15,728 width=4,691) (actual time=2,749.190..2,749.192 rows=9 loops=3)

  • Sort Key: users_bluevineuser.created DESC
  • Sort Method: quicksort Memory: 57kB
  • Worker 0: Sort Method: quicksort Memory: 85kB
  • Worker 1: Sort Method: quicksort Memory: 53kB
4. 0.080 2,748.976 ↑ 1,747.6 9 3 / 3

Nested Loop Left Join (cost=160,206.47..435,079.74 rows=15,728 width=4,691) (actual time=1,773.555..2,748.976 rows=9 loops=3)

5. 0.000 2,747.917 ↑ 1,747.6 9 3 / 3

Nested Loop Left Join (cost=160,206.05..425,136.70 rows=15,728 width=4,318) (actual time=1,773.510..2,747.917 rows=9 loops=3)

6. 1,580.736 2,759.636 ↑ 1,747.6 9 3 / 3

Parallel Hash Left Join (cost=160,205.62..398,993.67 rows=15,728 width=1,616) (actual time=1,773.284..2,759.636 rows=9 loops=3)

  • 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))
  • Rows Removed by Filter: 300,529
7. 231.869 231.869 ↑ 1.3 300,537 3 / 3

Parallel Seq Scan on users_bluevineuser (cost=0.00..119,991.22 rows=399,553 width=770) (actual time=0.011..231.869 rows=300,537 loops=3)

  • Filter: ((company_id IS NULL) AND (NOT is_test))
  • Rows Removed by Filter: 1,507
8. 665.718 947.031 ↑ 1.2 302,045 3 / 3

Parallel Hash (cost=115,832.50..115,832.50 rows=373,050 width=846) (actual time=947.031..947.031 rows=302,045 loops=3)

  • Buckets: 262,144 Batches: 8 Memory Usage: 105,856kB
9. 281.313 281.313 ↑ 1.2 302,045 3 / 3

Parallel Seq Scan on users_bluevineusersettings (cost=0.00..115,832.50 rows=373,050 width=846) (actual time=0.007..281.313 rows=302,045 loops=3)

10. 2.739 2.739 ↑ 1.0 1 26 / 3

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

  • Index Cond: (users_bluevineuser.id = user_id)
11. 0.979 0.979 ↑ 1.0 1 26 / 3

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

  • Index Cond: (users_bluevineuser.id = user_id)
Planning time : 1.894 ms
Execution time : 3,096.096 ms