explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JcX2

Settings
# exclusive inclusive rows x rows loops node
1. 25.160 11,478.986 ↑ 609.8 19 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.167 11,453.826 ↑ 804.7 6 3 / 3

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

3. 0.081 11,453.646 ↑ 804.7 6 3 / 3

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

4. 0.242 11,453.474 ↑ 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,438.405..11,453.474 rows=1 loops=3)

5. 0.084 11,453.002 ↑ 4,828.0 1 3 / 3

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

  • Join Filter: (u.user_id = us.user_id)
6. 105.217 11,452.902 ↑ 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,437.832..11,452.902 rows=1 loops=3)

  • Hash Cond: (u.user_id = ctl_1.user_id)
7. 11,219.983 11,219.983 ↑ 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,231.441..11,219.983 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. 0.584 127.702 ↑ 73,386.9 7 3 / 3

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

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

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

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

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

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

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