explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ls4P

Settings
# exclusive inclusive rows x rows loops node
1. 63.778 13,076.662 ↑ 626.3 19 1

Gather (cost=65,320.51..365,928.59 rows=11,900 width=745) (actual time=13,022.410..13,076.662 rows=19 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.557 13,012.884 ↑ 826.3 6 3 / 3

Nested Loop Left Join (cost=64,320.51..363,738.59 rows=4,958 width=745) (actual time=12,741.191..13,012.884 rows=6 loops=3)

3. 0.764 13,012.207 ↑ 826.3 6 3 / 3

Nested Loop (cost=64,320.08..332,616.47 rows=4,958 width=695) (actual time=12,740.632..13,012.207 rows=6 loops=3)

  • Join Filter: (u.user_id = us.user_id)
4. 884.030 13,010.518 ↑ 826.3 6 3 / 3

Parallel Hash Left Join (cost=64,319.65..301,093.59 rows=4,958 width=603) (actual time=12,738.927..13,010.518 rows=6 loops=3)

  • Hash Cond: (ctl.ctl_id = ctlh.ctl_id)
5. 1.428 11,467.791 ↑ 4,958.0 1 3 / 3

Nested Loop Left Join (cost=30,205.53..260,141.22 rows=4,958 width=553) (actual time=11,467.754..11,467.791 rows=1 loops=3)

6. 61.038 11,457.961 ↑ 4,958.0 1 3 / 3

Parallel Hash Semi Join (cost=30,197.99..250,682.48 rows=4,958 width=469) (actual time=11,457.927..11,457.961 rows=1 loops=3)

  • Hash Cond: (u.user_id = ctl_1.user_id)
7. 11,279.031 11,279.031 ↑ 1.4 15,052 3 / 3

Parallel Seq Scan on users u (cost=0.00..215,801.83 rows=21,146 width=465) (actual time=612.815..11,279.031 rows=15,052 loops=3)

  • Filter: ((reg_date >= '2020-01-31 00:00:00+00'::timestamp with time zone) AND (reg_date <= '2020-09-01 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 1,298,106
8. 2.648 117.892 ↑ 73,475.1 7 3 / 3

Parallel Hash (cost=21,758.91..21,758.91 rows=514,326 width=4) (actual time=117.892..117.892 rows=7 loops=3)

  • Buckets: 131,072 Batches: 32 Memory Usage: 1,056kB
9. 115.244 115.244 ↑ 73,475.1 7 3 / 3

Parallel Seq Scan on crowd_translator_lang ctl_1 (cost=0.00..21,758.91 rows=514,326 width=4) (actual time=111.812..115.244 rows=7 loops=3)

  • Filter: ((level <> verified_level) AND (level = 1))
  • Rows Removed by Filter: 496,724
10. 6.868 8.402 ↑ 2.0 1 2 / 3

Hash Right Join (cost=7.55..9.43 rows=2 width=84) (actual time=12.594..12.603 rows=1 loops=2)

  • Hash Cond: (l.lang_id = ctl.lang_id)
11. 0.515 0.515 ↑ 1.0 63 2 / 3

Seq Scan on language l (cost=0.00..1.63 rows=63 width=50) (actual time=0.751..0.773 rows=63 loops=2)

12. 0.392 1.019 ↑ 2.0 1 2 / 3

Hash (cost=7.52..7.52 rows=2 width=34) (actual time=1.528..1.528 rows=1 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
13. 0.627 0.627 ↑ 2.0 1 2 / 3

Index Scan using crowd_translator_lang_user_id_lang_id_idx on crowd_translator_lang ctl (cost=0.43..7.52 rows=2 width=34) (actual time=0.939..0.940 rows=1 loops=2)

  • Index Cond: (user_id = u.user_id)
14. 216.332 658.697 ↑ 1.2 500,151 3 / 3

Parallel Hash (cost=20,226.94..20,226.94 rows=623,694 width=50) (actual time=658.697..658.697 rows=500,151 loops=3)

  • Buckets: 65,536 Batches: 64 Memory Usage: 2,400kB
15. 442.365 442.365 ↑ 1.2 500,151 3 / 3

Parallel Seq Scan on crowd_translator_lang_history ctlh (cost=0.00..20,226.94 rows=623,694 width=50) (actual time=0.247..442.365 rows=500,151 loops=3)

16. 0.925 0.925 ↑ 1.0 1 19 / 3

Index Scan using user_settings_uid on user_settings us (cost=0.43..6.35 rows=1 width=96) (actual time=0.146..0.146 rows=1 loops=19)

  • Index Cond: (user_id = ctl_1.user_id)
17. 0.120 0.120 ↑ 1.0 1 19 / 3

Index Scan using stat_user_tr_uid_idx on stat_user_tr sut (cost=0.43..6.27 rows=1 width=50) (actual time=0.018..0.019 rows=1 loops=19)

  • Index Cond: (user_id = u.user_id)