explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qjNj

Settings
# exclusive inclusive rows x rows loops node
1. 0.814 633.263 ↓ 1.2 135 1

Sort (cost=5,784.55..5,784.84 rows=113 width=11,284) (actual time=633.258..633.263 rows=135 loops=1)

  • Sort Key: orthographies.written_form, tokens.word_sense, tokens.spoken_form, pronunciation_comments_1.created, script_comments_1.created, lexicon_data_comments_1.created, pronunciation_comments_2.created, token_comments_1.created, token_comments_2.created, token_comments_3.created
  • Sort Method: quicksort Memory: 333kB
2. 0.221 632.449 ↓ 1.2 135 1

Nested Loop Left Join (cost=26.89..5,780.70 rows=113 width=11,284) (actual time=606.057..632.449 rows=135 loops=1)

3. 0.220 632.228 ↓ 1.2 135 1

Nested Loop Left Join (cost=26.75..5,762.30 rows=113 width=11,238) (actual time=606.048..632.228 rows=135 loops=1)

4. 0.213 632.008 ↓ 1.2 135 1

Nested Loop Left Join (cost=26.46..5,726.98 rows=113 width=11,066) (actual time=606.040..632.008 rows=135 loops=1)

5. 0.221 631.795 ↓ 1.2 135 1

Nested Loop Left Join (cost=26.03..5,675.73 rows=113 width=10,603) (actual time=606.031..631.795 rows=135 loops=1)

6. 0.211 631.574 ↓ 1.2 135 1

Nested Loop Left Join (cost=25.89..5,657.39 rows=113 width=10,557) (actual time=606.021..631.574 rows=135 loops=1)

7. 0.211 631.363 ↓ 1.2 135 1

Nested Loop Left Join (cost=25.46..5,603.67 rows=113 width=10,469) (actual time=606.012..631.363 rows=135 loops=1)

8. 0.207 631.152 ↓ 1.2 135 1

Nested Loop Left Join (cost=25.03..5,552.42 rows=113 width=10,006) (actual time=606.002..631.152 rows=135 loops=1)

9. 0.206 630.945 ↓ 1.2 135 1

Nested Loop Left Join (cost=24.88..5,534.08 rows=113 width=9,960) (actual time=605.993..630.945 rows=135 loops=1)

10. 0.211 630.739 ↓ 1.2 135 1

Nested Loop Left Join (cost=24.74..5,515.68 rows=113 width=9,914) (actual time=605.984..630.739 rows=135 loops=1)

11. 0.215 630.528 ↓ 1.2 135 1

Nested Loop Left Join (cost=24.45..5,480.36 rows=113 width=9,742) (actual time=605.975..630.528 rows=135 loops=1)

12. 0.241 630.313 ↓ 1.2 135 1

Nested Loop Left Join (cost=24.02..5,429.11 rows=113 width=9,279) (actual time=605.963..630.313 rows=135 loops=1)

13. 0.200 630.072 ↓ 1.2 135 1

Nested Loop Left Join (cost=22.87..5,101.57 rows=113 width=9,116) (actual time=605.954..630.072 rows=135 loops=1)

14. 0.202 629.872 ↓ 1.2 135 1

Nested Loop Left Join (cost=22.44..5,048.77 rows=113 width=8,998) (actual time=605.945..629.872 rows=135 loops=1)

15. 0.205 629.670 ↓ 1.2 135 1

Nested Loop Left Join (cost=22.29..5,030.42 rows=113 width=8,952) (actual time=605.937..629.670 rows=135 loops=1)

16. 0.196 629.465 ↓ 1.2 135 1

Nested Loop Left Join (cost=21.86..4,976.71 rows=113 width=8,864) (actual time=605.926..629.465 rows=135 loops=1)

17. 0.198 629.269 ↓ 1.2 135 1

Nested Loop Left Join (cost=21.43..4,925.46 rows=113 width=8,401) (actual time=605.916..629.269 rows=135 loops=1)

18. 0.243 629.071 ↓ 1.2 135 1

Nested Loop Left Join (cost=21.28..4,907.11 rows=113 width=8,355) (actual time=605.905..629.071 rows=135 loops=1)

19. 0.237 628.828 ↓ 1.2 135 1

Nested Loop Left Join (cost=20.13..4,579.58 rows=113 width=8,192) (actual time=605.896..628.828 rows=135 loops=1)

20. 0.187 627.916 ↓ 1.6 135 1

Nested Loop Left Join (cost=19.70..4,427.17 rows=87 width=7,974) (actual time=605.881..627.916 rows=135 loops=1)

21. 0.175 627.729 ↓ 1.6 135 1

Nested Loop Left Join (cost=19.27..4,194.40 rows=87 width=7,856) (actual time=605.873..627.729 rows=135 loops=1)

22. 0.175 627.554 ↓ 1.6 135 1

Nested Loop Left Join (cost=19.12..4,179.48 rows=87 width=7,810) (actual time=605.864..627.554 rows=135 loops=1)

23. 0.173 627.379 ↓ 1.6 135 1

Nested Loop Left Join (cost=18.98..4,161.87 rows=87 width=7,674) (actual time=605.856..627.379 rows=135 loops=1)

24. 0.170 627.206 ↓ 1.6 135 1

Nested Loop Left Join (cost=18.55..4,122.75 rows=87 width=7,211) (actual time=605.847..627.206 rows=135 loops=1)

25. 0.172 627.036 ↓ 1.6 135 1

Nested Loop Left Join (cost=18.40..4,108.63 rows=87 width=7,165) (actual time=605.838..627.036 rows=135 loops=1)

26. 0.172 626.864 ↓ 1.6 135 1

Nested Loop Left Join (cost=17.84..4,054.14 rows=87 width=7,063) (actual time=605.830..626.864 rows=135 loops=1)

27. 0.169 626.692 ↓ 1.6 135 1

Nested Loop Left Join (cost=17.41..4,015.02 rows=87 width=6,600) (actual time=605.822..626.692 rows=135 loops=1)

28. 0.201 626.523 ↓ 1.6 135 1

Nested Loop Left Join (cost=17.26..4,000.90 rows=87 width=6,554) (actual time=605.814..626.523 rows=135 loops=1)

29. 0.175 626.322 ↓ 1.6 135 1

Nested Loop Left Join (cost=15.85..3,713.91 rows=87 width=6,377) (actual time=605.804..626.322 rows=135 loops=1)

30. 0.155 626.147 ↓ 1.6 135 1

Nested Loop Left Join (cost=15.42..3,672.46 rows=87 width=6,257) (actual time=605.795..626.147 rows=135 loops=1)

31. 0.212 625.992 ↓ 1.6 135 1

Nested Loop Left Join (cost=15.27..3,657.54 rows=87 width=6,211) (actual time=605.787..625.992 rows=135 loops=1)

32. 0.154 625.780 ↓ 1.6 135 1

Nested Loop Left Join (cost=15.12..3,639.92 rows=87 width=6,075) (actual time=605.773..625.780 rows=135 loops=1)

33. 0.089 625.491 ↓ 1.6 135 1

Nested Loop Left Join (cost=14.69..3,600.82 rows=87 width=5,612) (actual time=605.763..625.491 rows=135 loops=1)

34. 0.170 625.267 ↓ 1.6 135 1

Nested Loop Left Join (cost=14.55..3,586.70 rows=87 width=5,566) (actual time=605.753..625.267 rows=135 loops=1)

35. 0.153 624.287 ↓ 1.6 135 1

Nested Loop Left Join (cost=13.99..3,533.61 rows=87 width=5,451) (actual time=605.722..624.287 rows=135 loops=1)

36. 0.145 624.134 ↓ 1.6 135 1

Nested Loop Left Join (cost=13.56..3,494.51 rows=87 width=4,988) (actual time=605.716..624.134 rows=135 loops=1)

37. 0.141 623.989 ↓ 1.6 135 1

Nested Loop Left Join (cost=13.41..3,480.39 rows=87 width=4,942) (actual time=605.709..623.989 rows=135 loops=1)

38. 0.155 623.848 ↓ 1.6 135 1

Nested Loop Left Join (cost=13.27..3,465.47 rows=87 width=4,896) (actual time=605.700..623.848 rows=135 loops=1)

39. 0.142 623.693 ↓ 1.6 135 1

Nested Loop Left Join (cost=13.12..3,447.86 rows=87 width=4,760) (actual time=605.691..623.693 rows=135 loops=1)

40. 0.152 623.551 ↓ 1.6 135 1

Nested Loop Left Join (cost=12.69..3,405.32 rows=87 width=4,297) (actual time=605.684..623.551 rows=135 loops=1)

41. 0.193 623.399 ↓ 1.6 135 1

Nested Loop Left Join (cost=12.54..3,391.20 rows=87 width=4,251) (actual time=605.676..623.399 rows=135 loops=1)

42. 0.136 621.586 ↓ 1.6 135 1

Nested Loop Left Join (cost=11.00..3,104.24 rows=87 width=4,061) (actual time=605.642..621.586 rows=135 loops=1)

43. 0.130 621.450 ↓ 1.6 135 1

Nested Loop Left Join (cost=10.58..3,063.75 rows=87 width=3,967) (actual time=605.634..621.450 rows=135 loops=1)

44. 0.132 621.320 ↓ 1.6 135 1

Nested Loop Left Join (cost=10.15..3,021.22 rows=87 width=3,504) (actual time=605.627..621.320 rows=135 loops=1)

45. 0.130 621.188 ↓ 1.6 135 1

Nested Loop Left Join (cost=10.00..3,007.09 rows=87 width=3,458) (actual time=605.618..621.188 rows=135 loops=1)

46. 0.164 621.058 ↓ 1.6 135 1

Nested Loop Left Join (cost=9.86..2,992.18 rows=87 width=3,412) (actual time=605.610..621.058 rows=135 loops=1)

47. 0.048 620.894 ↓ 1.6 135 1

Nested Loop Left Join (cost=8.72..2,817.92 rows=87 width=3,243) (actual time=605.603..620.894 rows=135 loops=1)

48. 0.104 620.711 ↓ 1.6 135 1

Nested Loop Left Join (cost=8.57..2,800.30 rows=87 width=3,107) (actual time=605.589..620.711 rows=135 loops=1)

49. 0.106 619.932 ↓ 1.6 135 1

Nested Loop Left Join (cost=8.14..2,761.18 rows=87 width=2,644) (actual time=605.560..619.932 rows=135 loops=1)

50. 0.199 619.691 ↓ 1.6 135 1

Nested Loop Left Join (cost=8.00..2,747.06 rows=87 width=2,598) (actual time=605.550..619.691 rows=135 loops=1)

51. 0.129 618.412 ↓ 1.6 135 1

Nested Loop Left Join (cost=7.43..2,692.58 rows=87 width=2,496) (actual time=605.528..618.412 rows=135 loops=1)

52. 0.118 618.283 ↓ 1.6 135 1

Nested Loop Left Join (cost=7.00..2,653.46 rows=87 width=2,033) (actual time=605.519..618.283 rows=135 loops=1)

53. 0.033 618.165 ↓ 1.6 135 1

Nested Loop Left Join (cost=6.86..2,639.34 rows=87 width=1,987) (actual time=605.504..618.165 rows=135 loops=1)

54. 0.138 617.592 ↓ 1.6 135 1

Nested Loop Left Join (cost=5.88..2,394.15 rows=87 width=1,885) (actual time=605.490..617.592 rows=135 loops=1)

55. 0.154 616.509 ↓ 1.6 135 1

Nested Loop Left Join (cost=5.45..2,352.35 rows=87 width=1,810) (actual time=605.461..616.509 rows=135 loops=1)

56. 0.053 616.220 ↓ 1.6 135 1

Nested Loop Left Join (cost=5.02..2,312.89 rows=87 width=1,347) (actual time=605.455..616.220 rows=135 loops=1)

57. 0.030 616.032 ↓ 1.6 135 1

Nested Loop Left Join (cost=4.87..2,298.77 rows=87 width=1,301) (actual time=605.449..616.032 rows=135 loops=1)

58. 0.116 615.327 ↓ 1.6 135 1

Nested Loop Left Join (cost=4.44..2,257.42 rows=87 width=1,213) (actual time=605.443..615.327 rows=135 loops=1)

59. 0.105 615.211 ↓ 1.6 135 1

Nested Loop Left Join (cost=4.01..2,217.96 rows=87 width=750) (actual time=605.436..615.211 rows=135 loops=1)

60. 0.143 615.106 ↓ 1.6 135 1

Nested Loop Left Join (cost=3.87..2,203.84 rows=87 width=704) (actual time=605.428..615.106 rows=135 loops=1)

61. 0.155 614.558 ↓ 1.6 135 1

Nested Loop Left Join (cost=3.15..1,993.24 rows=87 width=616) (actual time=605.415..614.558 rows=135 loops=1)

  • Join Filter: (lexicons.id = lexicon_data.lexicon_id)
  • Rows Removed by Join Filter: 423
62. 0.085 614.403 ↓ 1.6 135 1

Nested Loop Left Join (cost=3.15..1,974.89 rows=87 width=532) (actual time=605.403..614.403 rows=135 loops=1)

63. 0.129 612.940 ↓ 2.3 106 1

Nested Loop Left Join (cost=2.58..1,944.60 rows=47 width=468) (actual time=605.371..612.940 rows=106 loops=1)

64. 0.079 611.963 ↓ 2.3 106 1

Nested Loop Left Join (cost=2.15..1,819.58 rows=47 width=393) (actual time=605.348..611.963 rows=106 loops=1)

65. 0.102 611.884 ↓ 2.3 106 1

Nested Loop Left Join (cost=1.73..1,798.12 rows=47 width=393) (actual time=605.336..611.884 rows=106 loops=1)

66. 0.304 611.358 ↓ 2.3 106 1

Nested Loop Left Join (cost=1.30..1,776.75 rows=47 width=294) (actual time=605.321..611.358 rows=106 loops=1)

  • Filter: (((orthographies.locale = ANY ('{en-US,en,und}'::text[])) AND (NOT (SubPlan 1))) OR ((orthographies.locale = ANY ('{en-US,en,und}'::text[])) AND (NOT (SubPlan 2))) OR (pronunciations.lex_locale = ANY ('{en-US,en,und}'::text[])))
67. 0.019 610.436 ↑ 1.0 100 1

Limit (cost=0.86..1,189.18 rows=100 width=174) (actual time=605.286..610.436 rows=100 loops=1)

68. 318.726 610.417 ↑ 31,693.4 100 1

Nested Loop Left Join (cost=0.86..37,661,862.43 rows=3,169,343 width=174) (actual time=605.285..610.417 rows=100 loops=1)

  • Filter: (((orthographies.locale = ANY ('{en-US,en,und}'::text[])) AND (NOT (SubPlan 3))) OR ((orthographies.locale = ANY ('{en-US,en,und}'::text[])) AND (NOT (SubPlan 4))) OR (alternatives: SubPlan 5 or hashed SubPlan 6))
  • Rows Removed by Filter: 1,193
69. 1.212 1.212 ↑ 18,095.1 304 1

Index Scan Backward using descending_written_form on orthographies (cost=0.43..171,555.27 rows=5,500,914 width=56) (actual time=0.024..1.212 rows=304 loops=1)

70. 3.040 3.040 ↓ 4.0 4 304

Index Scan using ix_tokens_orthography_id on tokens (cost=0.43..0.47 rows=1 width=118) (actual time=0.007..0.010 rows=4 loops=304)

  • Index Cond: (orthographies.id = orthography_id)
71.          

SubPlan (for Nested Loop Left Join)

72. 0.300 0.300 ↑ 1.0 1 100

Index Only Scan using ix_tokens_orthography_id on tokens tokens_4 (cost=0.43..1.55 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (orthography_id = orthographies.id)
  • Heap Fetches: 0
73. 0.800 0.800 ↑ 2.0 1 100

Index Only Scan using ix_pronunciations_token_id on pronunciations pronunciations_3 (cost=0.43..1.57 rows=2 width=0) (actual time=0.008..0.008 rows=1 loops=100)

  • Index Cond: (token_id = tokens.id)
  • Heap Fetches: 0
74. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pronunciations_token_id on pronunciations pronunciations_4 (cost=0.43..3.78 rows=1 width=0) (never executed)

  • Index Cond: (tokens.id = token_id)
  • Filter: (lex_locale = ANY ('{en-US,en,und}'::text[]))
75. 207.449 286.339 ↓ 1.0 1,200,525 1

Bitmap Heap Scan on pronunciations pronunciations_5 (cost=12,684.90..200,175.28 rows=1,192,901 width=16) (actual time=82.442..286.339 rows=1,200,525 loops=1)

  • Recheck Cond: (lex_locale = ANY ('{en-US,en,und}'::text[]))
  • Heap Blocks: exact=27,585
76. 78.890 78.890 ↓ 1.0 1,200,525 1

Bitmap Index Scan on ix_pronunciations_lex_locale (cost=0.00..12,386.67 rows=1,192,901 width=0) (actual time=78.890..78.890 rows=1,200,525 loops=1)

  • Index Cond: (lex_locale = ANY ('{en-US,en,und}'::text[]))
77. 0.300 0.300 ↑ 2.0 1 100

Index Scan using ix_pronunciations_token_id on pronunciations (cost=0.43..3.77 rows=2 width=120) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (tokens.id = token_id)
78.          

SubPlan (for Nested Loop Left Join)

79. 0.000 0.106 ↑ 5,753,811.0 1 106

Result (cost=0.00..124,345.11 rows=5,753,811 width=0) (actual time=0.001..0.001 rows=1 loops=106)

  • One-Time Filter: (orthographies.id = tokens.orthography_id)
80. 0.106 0.106 ↑ 5,753,811.0 1 106

Seq Scan on tokens tokens_3 (cost=0.00..124,345.11 rows=5,753,811 width=0) (actual time=0.001..0.001 rows=1 loops=106)

81. 0.212 0.212 ↑ 2.0 1 106

Index Only Scan using ix_pronunciations_token_id on pronunciations pronunciations_2 (cost=0.43..1.57 rows=2 width=0) (actual time=0.002..0.002 rows=1 loops=106)

  • Index Cond: (token_id = tokens.id)
  • Heap Fetches: 0
82. 0.424 0.424 ↓ 0.0 0 106

Index Scan using ix_scripts_pronunciation_id on scripts (cost=0.42..0.44 rows=1 width=99) (actual time=0.004..0.004 rows=0 loops=106)

  • Index Cond: (pronunciations.id = pronunciation_id)
83. 0.000 0.000 ↓ 0.0 0 106

Index Only Scan using ix_script_states_script_id on script_states (cost=0.42..0.45 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=106)

  • Index Cond: (script_id = scripts.id)
  • Heap Fetches: 0
84. 0.848 0.848 ↑ 1.0 1 106

Index Scan using ix_token_states_token_id on token_states token_states_1 (cost=0.43..2.65 rows=1 width=75) (actual time=0.008..0.008 rows=1 loops=106)

  • Index Cond: (tokens.id = token_id)
85. 1.378 1.378 ↑ 2.0 1 106

Index Scan using ix_lexicon_data_pronunciation_id on lexicon_data (cost=0.56..0.62 rows=2 width=64) (actual time=0.012..0.013 rows=1 loops=106)

  • Index Cond: (pronunciations.id = pronunciation_id)
86. 0.000 0.000 ↑ 3.5 4 135

Materialize (cost=0.00..1.21 rows=14 width=84) (actual time=0.000..0.000 rows=4 loops=135)

87. 0.008 0.008 ↑ 1.0 14 1

Seq Scan on lexicons (cost=0.00..1.14 rows=14 width=84) (actual time=0.004..0.008 rows=14 loops=1)

88. 0.000 0.405 ↓ 0.0 0 135

Nested Loop (cost=0.72..2.41 rows=1 width=104) (actual time=0.003..0.003 rows=0 loops=135)

89. 0.405 0.405 ↓ 0.0 0 135

Index Scan using ix_proposed_token_actions_token_state_id on proposed_token_actions proposed_token_actions_1 (cost=0.29..0.31 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=135)

  • Index Cond: (token_states_1.id = token_state_id)
90. 0.032 0.032 ↑ 1.0 1 2

Index Scan using token_actions_pkey on token_actions token_actions_1 (cost=0.43..2.11 rows=1 width=88) (actual time=0.016..0.016 rows=1 loops=2)

  • Index Cond: (id = proposed_token_actions_1.token_actions_id)
91. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_1 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_1.user_id)
92. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_1 (cost=0.43..0.45 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_1.action_list_id)
93. 0.675 0.675 ↓ 0.0 0 135

Index Scan using token_actions_pkey on token_actions token_actions_2 (cost=0.43..0.48 rows=1 width=88) (actual time=0.005..0.005 rows=0 loops=135)

  • Index Cond: (id = token_states_1.last_action_id)
94. 0.135 0.135 ↓ 0.0 0 135

Index Scan using users_pkey on users users_2 (cost=0.14..0.16 rows=1 width=46) (actual time=0.001..0.001 rows=0 loops=135)

  • Index Cond: (id = token_actions_2.user_id)
95. 0.135 0.135 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_2 (cost=0.43..0.45 rows=1 width=463) (actual time=0.001..0.001 rows=0 loops=135)

  • Index Cond: (id = token_actions_2.action_list_id)
96. 0.945 0.945 ↑ 1.0 1 135

Index Scan using ix_pron_states_pron_id on pron_states pron_states_1 (cost=0.43..0.47 rows=1 width=75) (actual time=0.007..0.007 rows=1 loops=135)

  • Index Cond: (pronunciations.id = pron_id)
97. 0.119 0.540 ↓ 0.0 0 135

Nested Loop (cost=0.98..2.81 rows=1 width=118) (actual time=0.004..0.004 rows=0 loops=135)

98. 0.405 0.405 ↓ 0.0 0 135

Index Scan using ix_proposed_pron_actions_pron_state_id on proposed_pron_actions proposed_pron_actions_1 (cost=0.41..0.43 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=135)

  • Index Cond: (pron_states_1.id = pron_state_id)
99. 0.016 0.016 ↑ 1.0 1 1

Index Scan using pron_actions_pkey on pron_actions pron_actions_1 (cost=0.56..2.38 rows=1 width=102) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (id = proposed_pron_actions_1.pron_actions_id)
100. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_3 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_1.user_id)
101. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_3 (cost=0.43..0.45 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_1.action_list_id)
102. 1.080 1.080 ↑ 1.0 1 135

Index Scan using pron_actions_pkey on pron_actions pron_actions_2 (cost=0.56..0.63 rows=1 width=102) (actual time=0.008..0.008 rows=1 loops=135)

  • Index Cond: (id = pron_states_1.last_action_id)
103. 0.135 0.135 ↑ 1.0 1 135

Index Scan using users_pkey on users users_4 (cost=0.14..0.16 rows=1 width=46) (actual time=0.001..0.001 rows=1 loops=135)

  • Index Cond: (id = pron_actions_2.user_id)
104. 0.675 0.675 ↑ 1.0 1 135

Index Scan using action_lists_pkey on action_lists action_lists_4 (cost=0.43..0.45 rows=1 width=463) (actual time=0.005..0.005 rows=1 loops=135)

  • Index Cond: (id = pron_actions_2.action_list_id)
105. 0.135 0.135 ↓ 0.0 0 135

Index Scan using ix_pronunciation_comments_pronunciation_id on pronunciation_comments pronunciation_comments_1 (cost=0.15..0.18 rows=2 width=136) (actual time=0.001..0.001 rows=0 loops=135)

  • Index Cond: (pronunciations.id = pronunciation_id)
106. 0.000 0.000 ↓ 0.0 0 135

Nested Loop Left Join (cost=1.14..1.99 rows=1 width=169) (actual time=0.000..0.000 rows=0 loops=135)

107. 0.000 0.000 ↓ 0.0 0 135

Index Scan using ix_script_states_script_id on script_states script_states_1 (cost=0.42..0.46 rows=1 width=75) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (scripts.id = script_id)
108. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.71..1.52 rows=1 width=110) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_proposed_script_actions_script_state_id on proposed_script_actions proposed_script_actions_1 (cost=0.29..0.31 rows=1 width=32) (never executed)

  • Index Cond: (script_states_1.id = script_state_id)
110. 0.000 0.000 ↓ 0.0 0

Index Scan using script_actions_pkey on script_actions script_actions_1 (cost=0.42..1.22 rows=1 width=94) (never executed)

  • Index Cond: (id = proposed_script_actions_1.script_actions_id)
111. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_5 (cost=0.14..0.17 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pronunciation_comments_1.creator_id)
112. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_6 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = script_actions_1.user_id)
113. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_5 (cost=0.43..0.49 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = script_actions_1.action_list_id)
114. 0.000 0.000 ↓ 0.0 0 135

Index Scan using script_actions_pkey on script_actions script_actions_2 (cost=0.42..0.47 rows=1 width=94) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = script_states_1.last_action_id)
115. 0.085 1.620 ↑ 1.0 1 135

Nested Loop Left Join (cost=1.54..3.29 rows=1 width=190) (actual time=0.012..0.012 rows=1 loops=135)

116. 0.945 0.945 ↑ 1.0 1 135

Index Scan using ix_lexicon_data_state_lexicon_pron_occurrence_id on lexicon_data_state lexicon_data_state_1 (cost=0.56..0.60 rows=1 width=75) (actual time=0.007..0.007 rows=1 loops=135)

  • Index Cond: (lexicon_data.id = lexicon_pron_occurrence_id)
117. 0.080 0.590 ↓ 0.0 0 118

Nested Loop (cost=0.98..2.68 rows=1 width=131) (actual time=0.005..0.005 rows=0 loops=118)

118. 0.472 0.472 ↓ 0.0 0 118

Index Scan using ix_proposed_lexicon_pron_occurrence_actions_lexicon_pro_2ef3 on proposed_lexicon_pron_occurrence_actions proposed_lexicon_pron_occurrence_actions_1 (cost=0.42..0.44 rows=1 width=32) (actual time=0.004..0.004 rows=0 loops=118)

  • Index Cond: (lexicon_data_state_1.id = lexicon_pron_occurrence_state_id)
119. 0.038 0.038 ↑ 1.0 1 2

Index Scan using lexicon_data_actions_pkey on lexicon_data_actions lexicon_data_actions_1 (cost=0.56..2.25 rows=1 width=115) (actual time=0.019..0.019 rows=1 loops=2)

  • Index Cond: (id = proposed_lexicon_pron_occurrence_actions_1.lexicon_pron_occurrence_actions_id)
120. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_7 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = script_actions_2.user_id)
121. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_6 (cost=0.43..0.49 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = script_actions_2.action_list_id)
122. 0.000 0.000 ↓ 0.0 0 135

Index Scan using ix_script_comments_script_id on script_comments script_comments_1 (cost=0.15..0.18 rows=2 width=136) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (scripts.id = script_id)
123. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_8 (cost=0.14..0.17 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = script_comments_1.creator_id)
124. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_9 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_actions_1.user_id)
125. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_7 (cost=0.43..0.45 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_actions_1.action_list_id)
126. 0.810 0.810 ↓ 0.0 0 135

Index Scan using lexicon_data_actions_pkey on lexicon_data_actions lexicon_data_actions_2 (cost=0.56..0.61 rows=1 width=115) (actual time=0.006..0.006 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_state_1.last_action_id)
127. 0.135 0.135 ↓ 0.0 0 135

Index Scan using users_pkey on users users_10 (cost=0.14..0.16 rows=1 width=46) (actual time=0.001..0.001 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_actions_2.user_id)
128. 0.135 0.135 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_8 (cost=0.43..0.45 rows=1 width=463) (actual time=0.001..0.001 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_actions_2.action_list_id)
129. 0.000 0.000 ↓ 0.0 0 135

Index Scan using ix_lexicon_data_comments_lexicon_data_id on lexicon_data_comments lexicon_data_comments_1 (cost=0.15..0.18 rows=2 width=136) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (lexicon_data.id = lexicon_data_id)
130. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_11 (cost=0.14..0.17 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_comments_1.creator_id)
131. 0.000 0.000 ↓ 0.0 0 135

Index Scan using pronunciations_pkey on pronunciations pronunciations_1 (cost=0.43..0.48 rows=1 width=120) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pronunciations.original_id)
132. 0.000 0.000 ↓ 0.0 0 135

Nested Loop Left Join (cost=1.41..3.29 rows=1 width=177) (actual time=0.000..0.000 rows=0 loops=135)

133. 0.000 0.000 ↓ 0.0 0 135

Index Scan using ix_pron_states_pron_id on pron_states pron_states_2 (cost=0.43..0.47 rows=1 width=75) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (pronunciations_1.id = pron_id)
134. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.98..2.81 rows=1 width=118) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_proposed_pron_actions_pron_state_id on proposed_pron_actions proposed_pron_actions_2 (cost=0.41..0.43 rows=1 width=32) (never executed)

  • Index Cond: (pron_states_2.id = pron_state_id)
136. 0.000 0.000 ↓ 0.0 0

Index Scan using pron_actions_pkey on pron_actions pron_actions_3 (cost=0.56..2.38 rows=1 width=102) (never executed)

  • Index Cond: (id = proposed_pron_actions_2.pron_actions_id)
137. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_12 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_3.user_id)
138. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_9 (cost=0.43..0.45 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_3.action_list_id)
139. 0.000 0.000 ↓ 0.0 0 135

Index Scan using pron_actions_pkey on pron_actions pron_actions_4 (cost=0.56..0.63 rows=1 width=102) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_states_2.last_action_id)
140. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_13 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_4.user_id)
141. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_10 (cost=0.43..0.45 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_4.action_list_id)
142. 0.000 0.000 ↓ 0.0 0 135

Index Scan using ix_pronunciation_comments_pronunciation_id on pronunciation_comments pronunciation_comments_2 (cost=0.15..0.18 rows=2 width=136) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (pronunciations_1.id = pronunciation_id)
143. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_14 (cost=0.14..0.17 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pronunciation_comments_2.creator_id)
144. 0.000 0.000 ↓ 0.0 0 135

Index Scan using tokens_pkey on tokens tokens_2 (cost=0.43..2.65 rows=1 width=118) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = tokens.original_id)
145. 0.000 0.675 ↓ 0.0 0 135

Nested Loop Left Join (cost=0.43..1.74 rows=1 width=218) (actual time=0.005..0.005 rows=0 loops=135)

146. 0.675 0.675 ↓ 0.0 0 135

Index Scan using ix_token_comments_token_id on token_comments token_comments_1 (cost=0.29..1.58 rows=1 width=172) (actual time=0.005..0.005 rows=0 loops=135)

  • Index Cond: (tokens.id = token_id)
147. 0.000 0.000 ↓ 0.0 0

Index Scan using users_pkey on users users_15 (cost=0.14..0.16 rows=1 width=46) (never executed)

  • Index Cond: (id = token_comments_1.creator_id)
148. 0.000 0.000 ↓ 0.0 0 135

Nested Loop Left Join (cost=1.15..2.89 rows=1 width=163) (actual time=0.000..0.000 rows=0 loops=135)

149. 0.000 0.000 ↓ 0.0 0 135

Index Scan using ix_token_states_token_id on token_states token_states_2 (cost=0.43..0.47 rows=1 width=75) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (tokens_2.id = token_id)
150. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..2.41 rows=1 width=104) (never executed)

151. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_proposed_token_actions_token_state_id on proposed_token_actions proposed_token_actions_2 (cost=0.29..0.31 rows=1 width=32) (never executed)

  • Index Cond: (token_states_2.id = token_state_id)
152. 0.000 0.000 ↓ 0.0 0

Index Scan using token_actions_pkey on token_actions token_actions_3 (cost=0.43..2.11 rows=1 width=88) (never executed)

  • Index Cond: (id = proposed_token_actions_2.token_actions_id)
153. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_16 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_3.user_id)
154. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_11 (cost=0.43..0.45 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_3.action_list_id)
155. 0.000 0.000 ↓ 0.0 0 135

Index Scan using token_actions_pkey on token_actions token_actions_4 (cost=0.43..0.48 rows=1 width=88) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_states_2.last_action_id)
156. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_17 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_4.user_id)
157. 0.000 0.000 ↓ 0.0 0 135

Index Scan using tokens_pkey on tokens tokens_1 (cost=0.43..0.47 rows=1 width=118) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = tokens_2.original_id)
158. 0.000 0.000 ↓ 0.0 0 135

Nested Loop Left Join (cost=1.15..2.89 rows=1 width=163) (actual time=0.000..0.000 rows=0 loops=135)

159. 0.000 0.000 ↓ 0.0 0 135

Index Scan using ix_token_states_token_id on token_states token_states_3 (cost=0.43..0.47 rows=1 width=75) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (tokens_1.id = token_id)
160. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.72..2.41 rows=1 width=104) (never executed)

161. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_proposed_token_actions_token_state_id on proposed_token_actions proposed_token_actions_3 (cost=0.29..0.31 rows=1 width=32) (never executed)

  • Index Cond: (token_states_3.id = token_state_id)
162. 0.000 0.000 ↓ 0.0 0

Index Scan using token_actions_pkey on token_actions token_actions_5 (cost=0.43..2.11 rows=1 width=88) (never executed)

  • Index Cond: (id = proposed_token_actions_3.token_actions_id)
163. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_12 (cost=0.43..0.45 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_4.action_list_id)
164. 0.000 0.000 ↓ 0.0 0 135

Index Scan using ix_token_comments_token_id on token_comments token_comments_2 (cost=0.29..0.30 rows=1 width=172) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (tokens_2.id = token_id)
165. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_18 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_comments_2.creator_id)
166. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_19 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_5.user_id)
167. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_13 (cost=0.43..0.45 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_5.action_list_id)
168. 0.000 0.000 ↓ 0.0 0 135

Index Scan using token_actions_pkey on token_actions token_actions_6 (cost=0.43..0.48 rows=1 width=88) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_states_3.last_action_id)
169. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_20 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_6.user_id)
170. 0.000 0.000 ↓ 0.0 0 135

Index Scan using action_lists_pkey on action_lists action_lists_14 (cost=0.43..0.45 rows=1 width=463) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_6.action_list_id)
171. 0.000 0.000 ↓ 0.0 0 135

Index Scan using ix_token_comments_token_id on token_comments token_comments_3 (cost=0.29..0.30 rows=1 width=172) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (tokens_1.id = token_id)
172. 0.000 0.000 ↓ 0.0 0 135

Index Scan using users_pkey on users users_21 (cost=0.14..0.16 rows=1 width=46) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_comments_3.creator_id)
Planning time : 62.972 ms
Execution time : 641.389 ms