explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OMfp

Settings
# exclusive inclusive rows x rows loops node
1. 244.193 20,035.228 ↓ 0.0 0 1

Gather (cost=747,811.49..1,811,299.22 rows=2 width=152) (actual time=19,798.409..20,035.228 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 11,489.565 19,791.035 ↓ 0.0 0 3 / 3

Parallel Hash Left Join (cost=746,811.49..1,810,299.02 rows=1 width=152) (actual time=19,790.989..19,791.035 rows=0 loops=3)

  • Hash Cond: (auth_user.id = account_userprofile.user_id)
  • Filter: (((account_userprofile.phone)::text = '+79997654321'::text) OR ((auth_user.email)::text = '+79997654321'::text))
  • Rows Removed by Filter: 6165514
3. 2,864.903 2,864.903 ↑ 1.2 6,165,514 3 / 3

Parallel Seq Scan on auth_user (cost=0.00..671,854.08 rows=7,599,408 width=152) (actual time=0.012..2,864.903 rows=6,165,514 loops=3)

4. 1,692.149 5,436.567 ↑ 1.2 6,165,514 3 / 3

Parallel Hash (cost=605,352.55..605,352.55 rows=7,704,955 width=17) (actual time=5,436.566..5,436.567 rows=6,165,514 loops=3)

  • Buckets: 1048576 Batches: 32 Memory Usage: 31392kB
5. 3,744.418 3,744.418 ↑ 1.2 6,165,514 3 / 3

Parallel Seq Scan on account_userprofile (cost=0.00..605,352.55 rows=7,704,955 width=17) (actual time=0.020..3,744.418 rows=6,165,514 loops=3)

Planning time : 0.372 ms
Execution time : 20,035.412 ms