explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jBg5

Settings
# exclusive inclusive rows x rows loops node
1. 32.136 12,897.180 ↑ 609.8 19 1

Gather (cost=65,291.45..389,467.82 rows=11,586 width=695) (actual time=12,872.938..12,897.180 rows=19 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.015 12,865.044 ↑ 804.7 6 3 / 3

Nested Loop Left Join (cost=64,291.45..387,309.22 rows=4,828 width=695) (actual time=12,642.657..12,865.044 rows=6 loops=3)

3. 765.700 12,865.010 ↑ 804.7 6 3 / 3

Parallel Hash Left Join (cost=64,291.02..356,997.15 rows=4,828 width=645) (actual time=12,642.576..12,865.010 rows=6 loops=3)

  • Hash Cond: (ctl.ctl_id = ctlh.ctl_id)
4. 0.005 11,692.375 ↑ 4,828.0 1 3 / 3

Nested Loop Left Join (cost=30,176.90..316,017.81 rows=4,828 width=595) (actual time=11,680.107..11,692.375 rows=1 loops=3)

5. 0.089 11,692.021 ↑ 4,828.0 1 3 / 3

Nested Loop (cost=30,176.47..285,670.86 rows=4,828 width=561) (actual time=11,679.757..11,692.021 rows=1 loops=3)

  • Join Filter: (u.user_id = us.user_id)
6. 102.391 11,691.919 ↑ 4,870.0 1 3 / 3

Parallel Hash Semi Join (cost=30,176.04..254,707.28 rows=4,870 width=469) (actual time=11,679.661..11,691.919 rows=1 loops=3)

  • Hash Cond: (u.user_id = ctl_1.user_id)
7. 11,457.560 11,457.560 ↑ 1.4 14,683 3 / 3

Parallel Seq Scan on users u (cost=0.00..219,895.47 rows=20,795 width=465) (actual time=909.912..11,457.560 rows=14,683 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) AND (valid = 'Y'::bpchar))
  • Rows Removed by Filter: 1,298,475
8. 3.105 131.968 ↑ 73,386.9 7 3 / 3

Parallel Hash (cost=21,747.69..21,747.69 rows=513,708 width=4) (actual time=131.968..131.968 rows=7 loops=3)

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

Parallel Seq Scan on crowd_translator_lang ctl_1 (cost=0.00..21,747.69 rows=513,708 width=4) (actual time=124.118..128.863 rows=7 loops=3)

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

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

  • Index Cond: (user_id = ctl_1.user_id)
11. 0.349 0.349 ↑ 2.0 1 2 / 3

Index Scan using crowd_translator_lang_user_id_idx on crowd_translator_lang ctl (cost=0.43..6.27 rows=2 width=34) (actual time=0.523..0.524 rows=1 loops=2)

  • Index Cond: (user_id = u.user_id)
12. 279.150 406.935 ↑ 1.2 500,151 3 / 3

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

  • Buckets: 65,536 Batches: 64 Memory Usage: 2,368kB
13. 127.785 127.785 ↑ 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.007..127.785 rows=500,151 loops=3)

14. 0.019 0.019 ↑ 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.003..0.003 rows=1 loops=19)

  • Index Cond: (user_id = u.user_id)
Planning time : 2.307 ms
Execution time : 12,902.081 ms