explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QEwj

Settings
# exclusive inclusive rows x rows loops node
1. 30.510 11,015.037 ↑ 609.8 19 1

Gather (cost=31,177.76..378,419.53 rows=11,586 width=695) (actual time=11,005.360..11,015.037 rows=19 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.954 10,984.527 ↑ 804.7 6 3 / 3

Nested Loop Left Join (cost=30,177.76..376,260.93 rows=4,828 width=695) (actual time=10,971.632..10,984.527 rows=6 loops=3)

3. 0.686 10,983.237 ↑ 804.7 6 3 / 3

Nested Loop Left Join (cost=30,177.33..345,948.86 rows=4,828 width=645) (actual time=10,970.427..10,983.237 rows=6 loops=3)

4. 0.683 10,982.116 ↑ 4,828.0 1 3 / 3

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

5. 0.539 10,981.099 ↑ 4,828.0 1 3 / 3

Nested Loop (cost=30,176.47..285,670.86 rows=4,828 width=561) (actual time=10,968.445..10,981.099 rows=1 loops=3)

  • Join Filter: (u.user_id = us.user_id)
6. 97.817 10,979.823 ↑ 4,870.0 1 3 / 3

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

  • Hash Cond: (u.user_id = ctl_1.user_id)
7. 10,724.734 10,724.734 ↑ 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=1,081.045..10,724.734 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. 4.435 157.272 ↑ 73,386.9 7 3 / 3

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

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

  • Filter: ((level <> verified_level) AND (level = 1))
  • Rows Removed by Filter: 496,724
10. 0.737 0.737 ↑ 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=1.104..1.105 rows=1 loops=2)

  • Index Cond: (user_id = ctl_1.user_id)
11. 0.334 0.334 ↑ 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.500..0.501 rows=1 loops=2)

  • Index Cond: (user_id = u.user_id)
12. 0.435 0.435 ↓ 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.646..0.652 rows=10 loops=2)

  • Index Cond: (ctl_id = ctl.ctl_id)
13. 0.336 0.336 ↑ 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.052..0.053 rows=1 loops=19)

  • Index Cond: (user_id = u.user_id)
Planning time : 4.032 ms
Execution time : 11,016.880 ms