explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W4T9

Settings
# exclusive inclusive rows x rows loops node
1. 19.418 10,946.498 ↑ 625.6 19 1

Gather (cost=31,183.62..355,561.29 rows=11,886 width=745) (actual time=10,916.459..10,946.498 rows=19 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.452 10,927.080 ↑ 825.3 6 3 / 3

Nested Loop Left Join (cost=30,183.62..353,372.69 rows=4,952 width=745) (actual time=10,921.337..10,927.080 rows=6 loops=3)

3. 0.385 10,926.539 ↑ 4,952.0 1 3 / 3

Nested Loop Left Join (cost=30,183.19..322,672.90 rows=4,952 width=695) (actual time=10,920.889..10,926.539 rows=1 loops=3)

4. 0.151 10,925.950 ↑ 4,952.0 1 3 / 3

Nested Loop (cost=30,182.76..291,588.45 rows=4,952 width=645) (actual time=10,920.390..10,925.950 rows=1 loops=3)

  • Join Filter: (u.user_id = us.user_id)
5. 0.194 10,925.650 ↑ 4,952.0 1 3 / 3

Nested Loop Left Join (cost=30,182.33..260,103.51 rows=4,952 width=553) (actual time=10,920.163..10,925.650 rows=1 loops=3)

6. 90.391 10,922.774 ↑ 4,952.0 1 3 / 3

Parallel Hash Semi Join (cost=30,176.04..250,657.47 rows=4,952 width=469) (actual time=10,917.292..10,922.774 rows=1 loops=3)

  • Hash Cond: (u.user_id = ctl_1.user_id)
7. 10,711.574 10,711.574 ↑ 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=646.083..10,711.574 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.265 120.809 ↑ 73,386.9 7 3 / 3

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

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

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

Hash Right Join (cost=6.29..8.18 rows=2 width=84) (actual time=4.012..4.023 rows=1 loops=2)

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

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

12. 0.137 0.645 ↑ 2.0 1 2 / 3

Hash (cost=6.26..6.26 rows=2 width=34) (actual time=0.967..0.967 rows=1 loops=2)

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

Index Scan using crowd_translator_lang_user_id_idx on crowd_translator_lang ctl (cost=0.43..6.26 rows=2 width=34) (actual time=0.760..0.761 rows=1 loops=2)

  • Index Cond: (user_id = u.user_id)
14. 0.149 0.149 ↑ 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.223..0.224 rows=1 loops=2)

  • Index Cond: (user_id = ctl_1.user_id)
15. 0.204 0.204 ↓ 0.0 0 2 / 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.305..0.306 rows=0 loops=2)

  • Index Cond: (user_id = u.user_id)
16. 0.089 0.089 ↓ 10.0 10 2 / 3

Index Scan using crowd_translator_lang_history_ctl_id_idx on crowd_translator_lang_history ctlh (cost=0.43..6.19 rows=1 width=50) (actual time=0.127..0.134 rows=10 loops=2)

  • Index Cond: (ctl_id = ctl.ctl_id)