explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DIFr

Settings
# exclusive inclusive rows x rows loops node
1. 55.002 14,133.782 ↑ 620.8 19 1

Gather (cost=96,591.33..392,885.34 rows=11,796 width=695) (actual time=13,824.605..14,133.782 rows=19 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.514 14,078.780 ↑ 819.2 6 3 / 3

Nested Loop Left Join (cost=95,591.33..390,705.74 rows=4,915 width=695) (actual time=13,771.335..14,078.780 rows=6 loops=3)

3. 0.723 14,078.000 ↑ 819.2 6 3 / 3

Nested Loop (cost=95,590.90..359,853.54 rows=4,915 width=645) (actual time=13,770.656..14,078.000 rows=6 loops=3)

  • Join Filter: (u.user_id = us.user_id)
4. 770.024 14,076.321 ↑ 826.3 6 3 / 3

Parallel Hash Left Join (cost=95,590.48..328,330.66 rows=4,958 width=553) (actual time=13,768.965..14,076.321 rows=6 loops=3)

  • Hash Cond: (ctl.ctl_id = ctlh.ctl_id)
5. 658.093 12,893.003 ↑ 4,958.0 1 3 / 3

Parallel Hash Left Join (cost=61,476.36..287,446.29 rows=4,958 width=503) (actual time=12,815.128..12,893.003 rows=1 loops=3)

  • Hash Cond: (u.user_id = ctl.user_id)
6. 110.090 11,882.345 ↑ 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,869.224..11,882.345 rows=1 loops=3)

  • Hash Cond: (u.user_id = ctl_1.user_id)
7. 11,658.366 11,658.366 ↑ 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=741.811..11,658.366 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. 1.929 113.889 ↑ 73,475.1 7 3 / 3

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

  • Buckets: 131,072 Batches: 32 Memory Usage: 1,056kB
9. 111.960 111.960 ↑ 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=108.777..111.960 rows=7 loops=3)

  • Filter: ((level <> verified_level) AND (level = 1))
  • Rows Removed by Filter: 496,724
10. 235.316 352.565 ↑ 1.3 496,730 3 / 3

Parallel Hash (cost=18,650.61..18,650.61 rows=621,661 width=34) (actual time=352.565..352.565 rows=496,730 loops=3)

  • Buckets: 65,536 Batches: 32 Memory Usage: 3,872kB
11. 117.249 117.249 ↑ 1.3 496,730 3 / 3

Parallel Seq Scan on crowd_translator_lang ctl (cost=0.00..18,650.61 rows=621,661 width=34) (actual time=0.008..117.249 rows=496,730 loops=3)

12. 296.409 413.294 ↑ 1.2 500,151 3 / 3

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

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

14. 0.956 0.956 ↑ 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.151..0.151 rows=1 loops=19)

  • Index Cond: (user_id = ctl_1.user_id)
15. 0.266 0.266 ↑ 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.042..0.042 rows=1 loops=19)

  • Index Cond: (user_id = u.user_id)