explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EumY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=2,018,619.76..15,982,818.94 rows=209,884,447 width=98) (actual rows= loops=)

  • Merge Cond: (stats.id_user = rat.id_user)
2. 0.000 0.000 ↓ 0.0

Merge Append (cost=605,090.53..3,450,192.86 rows=40,065,352 width=8) (actual rows= loops=)

  • Sort Key: stats.id_user
3. 0.000 0.000 ↓ 0.0

Index Only Scan using stat_part_1_id_user_idx on stat_part_1 stats (cost=0.43..238,197.58 rows=4,006,250 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Only Scan using stat_part_2_id_user_idx on stat_part_2 stats_1 (cost=0.43..228,795.38 rows=4,006,743 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Only Scan using stat_part_3_id_user_idx on stat_part_3 stats_2 (cost=0.43..234,719.11 rows=4,006,597 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Only Scan using stat_part_4_id_user_idx on stat_part_4 stats_3 (cost=0.43..217,676.72 rows=4,006,546 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Only Scan using stat_part_5_id_user_idx on stat_part_5 stats_4 (cost=0.43..221,048.72 rows=4,006,246 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Only Scan using stat_part_6_id_user_idx on stat_part_6 stats_5 (cost=0.43..228,894.81 rows=4,006,752 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Only Scan using stat_part_7_id_user_idx on stat_part_7 stats_6 (cost=0.43..233,025.74 rows=4,006,547 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Only Scan using stat_part_8_id_user_idx on stat_part_8 stats_7 (cost=0.43..234,225.06 rows=4,005,962 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Only Scan using stat_part_9_id_user_idx on stat_part_9 stats_8 (cost=0.43..232,871.81 rows=4,006,985 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Sort (cost=605,086.49..615,103.30 rows=4,006,724 width=8) (actual rows= loops=)

  • Sort Key: stats_9.id_user
13. 0.000 0.000 ↓ 0.0

Seq Scan on stat_part_10 stats_9 (cost=0.00..165,669.24 rows=4,006,724 width=8) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Sort (cost=1,413,529.23..1,415,912.25 rows=953,207 width=191) (actual rows= loops=)

  • Sort Key: rat.id_user
15. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=122,781.97..1,318,864.20 rows=953,207 width=191) (actual rows= loops=)

  • Hash Cond: (rat.id = se.id_rating)
16. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=122,235.03..1,314,738.08 rows=953,207 width=183) (actual rows= loops=)

  • Hash Cond: (rat.id = ss.id_rating)
17. 0.000 0.000 ↓ 0.0

Hash Join (cost=115,648.45..1,304,520.82 rows=953,207 width=167) (actual rows= loops=)

  • Hash Cond: (rat.id = rev.id)
  • Join Filter: (GREATEST(rev.updated_at, rat.updated_at) > '1970-01-01 00:00:00'::timestamp without time zone)
18. 0.000 0.000 ↓ 0.0

Append (cost=0.00..895,558.81 rows=40,067,081 width=63) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_1 rat (cost=0.00..89,534.59 rows=4,006,259 width=63) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_2 rat_1 (cost=0.00..89,547.44 rows=4,006,744 width=63) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_3 rat_2 (cost=0.00..89,544.97 rows=4,006,597 width=63) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_4 rat_3 (cost=0.00..89,540.46 rows=4,006,546 width=63) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_5 rat_4 (cost=0.00..89,535.47 rows=4,006,247 width=63) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_6 rat_5 (cost=0.00..89,551.52 rows=4,006,752 width=63) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_7 rat_6 (cost=0.00..89,554.48 rows=4,006,548 width=63) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_8 rat_7 (cost=0.00..89,548.64 rows=4,005,964 width=63) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_9 rat_8 (cost=0.00..89,579.02 rows=4,007,002 width=63) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on rating_part_10 rat_9 (cost=0.00..89,622.22 rows=4,008,422 width=63) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Hash (cost=79,903.20..79,903.20 rows=2,859,620 width=104) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Seq Scan on user_has_review rev (cost=0.00..79,903.20 rows=2,859,620 width=104) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=3,636.26..3,636.26 rows=236,026 width=16) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on relevant_seasons ss (cost=0.00..3,636.26 rows=236,026 width=16) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=301.97..301.97 rows=19,597 width=16) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on relevant_episodes se (cost=0.00..301.97 rows=19,597 width=16) (actual rows= loops=)