explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rwbm

Settings
# exclusive inclusive rows x rows loops node
1. 0.783 39.356 ↓ 1.2 135 1

Sort (cost=6,406.35..6,406.64 rows=115 width=10,052) (actual time=39.351..39.356 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.223 38.573 ↓ 1.2 135 1

Nested Loop Left Join (cost=26.89..6,402.42 rows=115 width=10,052) (actual time=4.979..38.573 rows=135 loops=1)

3. 0.218 38.350 ↓ 1.2 135 1

Nested Loop Left Join (cost=26.75..6,383.69 rows=115 width=10,006) (actual time=4.972..38.350 rows=135 loops=1)

4. 0.208 38.132 ↓ 1.2 135 1

Nested Loop Left Join (cost=26.46..6,347.75 rows=115 width=9,834) (actual time=4.966..38.132 rows=135 loops=1)

5. 0.209 37.924 ↓ 1.2 135 1

Nested Loop Left Join (cost=26.03..6,295.59 rows=115 width=9,459) (actual time=4.960..37.924 rows=135 loops=1)

6. 0.212 37.715 ↓ 1.2 135 1

Nested Loop Left Join (cost=25.89..6,276.92 rows=115 width=9,413) (actual time=4.954..37.715 rows=135 loops=1)

7. 0.206 37.503 ↓ 1.2 135 1

Nested Loop Left Join (cost=25.46..6,222.26 rows=115 width=9,325) (actual time=4.949..37.503 rows=135 loops=1)

8. 0.207 37.297 ↓ 1.2 135 1

Nested Loop Left Join (cost=25.03..6,170.10 rows=115 width=8,950) (actual time=4.944..37.297 rows=135 loops=1)

9. 0.198 37.090 ↓ 1.2 135 1

Nested Loop Left Join (cost=24.88..6,151.43 rows=115 width=8,904) (actual time=4.939..37.090 rows=135 loops=1)

10. 0.211 36.892 ↓ 1.2 135 1

Nested Loop Left Join (cost=24.74..6,132.70 rows=115 width=8,858) (actual time=4.934..36.892 rows=135 loops=1)

11. 0.199 36.681 ↓ 1.2 135 1

Nested Loop Left Join (cost=24.45..6,096.76 rows=115 width=8,686) (actual time=4.927..36.681 rows=135 loops=1)

12. 0.231 36.482 ↓ 1.2 135 1

Nested Loop Left Join (cost=24.02..6,044.60 rows=115 width=8,311) (actual time=4.921..36.482 rows=135 loops=1)

13. 0.198 36.251 ↓ 1.2 135 1

Nested Loop Left Join (cost=22.87..5,711.27 rows=115 width=8,148) (actual time=4.916..36.251 rows=135 loops=1)

14. 0.188 36.053 ↓ 1.2 135 1

Nested Loop Left Join (cost=22.44..5,657.53 rows=115 width=8,030) (actual time=4.911..36.053 rows=135 loops=1)

15. 0.199 35.865 ↓ 1.2 135 1

Nested Loop Left Join (cost=22.29..5,638.86 rows=115 width=7,984) (actual time=4.906..35.865 rows=135 loops=1)

16. 0.188 35.666 ↓ 1.2 135 1

Nested Loop Left Join (cost=21.86..5,584.19 rows=115 width=7,896) (actual time=4.901..35.666 rows=135 loops=1)

17. 0.198 35.478 ↓ 1.2 135 1

Nested Loop Left Join (cost=21.43..5,532.04 rows=115 width=7,521) (actual time=4.896..35.478 rows=135 loops=1)

18. 0.232 35.280 ↓ 1.2 135 1

Nested Loop Left Join (cost=21.28..5,513.37 rows=115 width=7,475) (actual time=4.888..35.280 rows=135 loops=1)

19. 0.180 35.048 ↓ 1.2 135 1

Nested Loop Left Join (cost=20.13..5,180.03 rows=115 width=7,312) (actual time=4.883..35.048 rows=135 loops=1)

20. 0.180 34.328 ↓ 1.5 135 1

Nested Loop Left Join (cost=19.70..5,024.12 rows=89 width=7,094) (actual time=4.874..34.328 rows=135 loops=1)

21. 0.179 34.148 ↓ 1.5 135 1

Nested Loop Left Join (cost=19.27..4,786.06 rows=89 width=6,976) (actual time=4.867..34.148 rows=135 loops=1)

22. 0.167 33.969 ↓ 1.5 135 1

Nested Loop Left Join (cost=19.12..4,770.79 rows=89 width=6,930) (actual time=4.860..33.969 rows=135 loops=1)

23. 0.169 33.802 ↓ 1.5 135 1

Nested Loop Left Join (cost=18.98..4,752.77 rows=89 width=6,794) (actual time=4.856..33.802 rows=135 loops=1)

24. 0.172 33.633 ↓ 1.5 135 1

Nested Loop Left Join (cost=18.55..4,712.75 rows=89 width=6,419) (actual time=4.851..33.633 rows=135 loops=1)

25. 0.164 33.461 ↓ 1.5 135 1

Nested Loop Left Join (cost=18.40..4,698.31 rows=89 width=6,373) (actual time=4.843..33.461 rows=135 loops=1)

26. 0.180 33.297 ↓ 1.5 135 1

Nested Loop Left Join (cost=17.84..4,642.57 rows=89 width=6,271) (actual time=4.839..33.297 rows=135 loops=1)

27. 0.161 33.117 ↓ 1.5 135 1

Nested Loop Left Join (cost=17.41..4,602.55 rows=89 width=5,896) (actual time=4.834..33.117 rows=135 loops=1)

28. 0.196 32.956 ↓ 1.5 135 1

Nested Loop Left Join (cost=17.26..4,588.11 rows=89 width=5,850) (actual time=4.829..32.956 rows=135 loops=1)

29. 0.166 32.760 ↓ 1.5 135 1

Nested Loop Left Join (cost=15.85..4,294.52 rows=89 width=5,673) (actual time=4.824..32.760 rows=135 loops=1)

30. 0.154 32.594 ↓ 1.5 135 1

Nested Loop Left Join (cost=15.42..4,252.11 rows=89 width=5,553) (actual time=4.820..32.594 rows=135 loops=1)

31. 0.205 32.440 ↓ 1.5 135 1

Nested Loop Left Join (cost=15.27..4,236.85 rows=89 width=5,507) (actual time=4.814..32.440 rows=135 loops=1)

32. 0.154 32.235 ↓ 1.5 135 1

Nested Loop Left Join (cost=15.12..4,218.83 rows=89 width=5,371) (actual time=4.806..32.235 rows=135 loops=1)

33. 0.078 31.946 ↓ 1.5 135 1

Nested Loop Left Join (cost=14.69..4,178.83 rows=89 width=4,996) (actual time=4.799..31.946 rows=135 loops=1)

34. 0.137 31.733 ↓ 1.5 135 1

Nested Loop Left Join (cost=14.55..4,164.38 rows=89 width=4,950) (actual time=4.792..31.733 rows=135 loops=1)

35. 0.152 31.191 ↓ 1.5 135 1

Nested Loop Left Join (cost=13.99..4,110.08 rows=89 width=4,835) (actual time=4.778..31.191 rows=135 loops=1)

36. 0.142 31.039 ↓ 1.5 135 1

Nested Loop Left Join (cost=13.56..4,070.08 rows=89 width=4,460) (actual time=4.774..31.039 rows=135 loops=1)

37. 0.140 30.897 ↓ 1.5 135 1

Nested Loop Left Join (cost=13.41..4,055.63 rows=89 width=4,414) (actual time=4.770..30.897 rows=135 loops=1)

38. 0.144 30.757 ↓ 1.5 135 1

Nested Loop Left Join (cost=13.27..4,040.37 rows=89 width=4,368) (actual time=4.765..30.757 rows=135 loops=1)

39. 0.144 30.613 ↓ 1.5 135 1

Nested Loop Left Join (cost=13.12..4,022.35 rows=89 width=4,232) (actual time=4.757..30.613 rows=135 loops=1)

40. 0.141 30.469 ↓ 1.5 135 1

Nested Loop Left Join (cost=12.69..3,978.83 rows=89 width=3,857) (actual time=4.750..30.469 rows=135 loops=1)

41. 0.167 30.328 ↓ 1.5 135 1

Nested Loop Left Join (cost=12.54..3,964.39 rows=89 width=3,811) (actual time=4.746..30.328 rows=135 loops=1)

42. 0.131 28.676 ↓ 1.5 135 1

Nested Loop Left Join (cost=11.00..3,670.83 rows=89 width=3,621) (actual time=4.721..28.676 rows=135 loops=1)

43. 0.125 28.545 ↓ 1.5 135 1

Nested Loop Left Join (cost=10.58..3,629.41 rows=89 width=3,527) (actual time=4.716..28.545 rows=135 loops=1)

44. 0.128 28.420 ↓ 1.5 135 1

Nested Loop Left Join (cost=10.15..3,585.90 rows=89 width=3,152) (actual time=4.711..28.420 rows=135 loops=1)

45. 0.133 28.292 ↓ 1.5 135 1

Nested Loop Left Join (cost=10.00..3,571.45 rows=89 width=3,106) (actual time=4.706..28.292 rows=135 loops=1)

46. 0.160 28.159 ↓ 1.5 135 1

Nested Loop Left Join (cost=9.86..3,556.19 rows=89 width=3,060) (actual time=4.700..28.159 rows=135 loops=1)

47. 0.171 27.999 ↓ 1.5 135 1

Nested Loop Left Join (cost=8.72..3,377.93 rows=89 width=2,891) (actual time=4.695..27.999 rows=135 loops=1)

48. 0.132 27.828 ↓ 1.5 135 1

Nested Loop Left Join (cost=8.57..3,359.91 rows=89 width=2,755) (actual time=4.689..27.828 rows=135 loops=1)

49. 0.098 27.291 ↓ 1.5 135 1

Nested Loop Left Join (cost=8.14..3,319.89 rows=89 width=2,380) (actual time=4.677..27.291 rows=135 loops=1)

50. 0.060 27.058 ↓ 1.5 135 1

Nested Loop Left Join (cost=8.00..3,305.44 rows=89 width=2,334) (actual time=4.671..27.058 rows=135 loops=1)

51. 0.115 26.323 ↓ 1.5 135 1

Nested Loop Left Join (cost=7.43..3,249.70 rows=89 width=2,232) (actual time=4.657..26.323 rows=135 loops=1)

52. 0.114 26.208 ↓ 1.5 135 1

Nested Loop Left Join (cost=7.00..3,209.68 rows=89 width=1,857) (actual time=4.653..26.208 rows=135 loops=1)

53. 0.135 26.094 ↓ 1.5 135 1

Nested Loop Left Join (cost=6.86..3,195.24 rows=89 width=1,811) (actual time=4.646..26.094 rows=135 loops=1)

54. 0.155 25.554 ↓ 1.5 135 1

Nested Loop Left Join (cost=5.88..2,944.42 rows=89 width=1,709) (actual time=4.635..25.554 rows=135 loops=1)

55. 0.138 24.724 ↓ 1.5 135 1

Nested Loop Left Join (cost=5.45..2,901.65 rows=89 width=1,634) (actual time=4.617..24.724 rows=135 loops=1)

56. 0.042 24.451 ↓ 1.5 135 1

Nested Loop Left Join (cost=5.02..2,861.29 rows=89 width=1,259) (actual time=4.612..24.451 rows=135 loops=1)

57. 0.149 24.274 ↓ 1.5 135 1

Nested Loop Left Join (cost=4.87..2,846.84 rows=89 width=1,213) (actual time=4.608..24.274 rows=135 loops=1)

58. 0.109 23.855 ↓ 1.5 135 1

Nested Loop Left Join (cost=4.44..2,804.54 rows=89 width=1,125) (actual time=4.603..23.855 rows=135 loops=1)

59. 0.100 23.746 ↓ 1.5 135 1

Nested Loop Left Join (cost=4.01..2,764.17 rows=89 width=750) (actual time=4.598..23.746 rows=135 loops=1)

60. 0.087 23.646 ↓ 1.5 135 1

Nested Loop Left Join (cost=3.87..2,749.73 rows=89 width=704) (actual time=4.594..23.646 rows=135 loops=1)

61. 0.151 23.154 ↓ 1.5 135 1

Nested Loop Left Join (cost=3.15..2,534.29 rows=89 width=616) (actual time=4.583..23.154 rows=135 loops=1)

  • Join Filter: (lexicons.id = lexicon_data.lexicon_id)
  • Rows Removed by Join Filter: 423
62. 0.058 23.003 ↓ 1.5 135 1

Nested Loop Left Join (cost=3.15..2,515.52 rows=89 width=532) (actual time=4.575..23.003 rows=135 loops=1)

63. 0.033 22.203 ↓ 2.2 106 1

Nested Loop Left Join (cost=2.58..2,484.59 rows=48 width=468) (actual time=4.560..22.203 rows=106 loops=1)

64. 0.075 21.428 ↓ 2.2 106 1

Nested Loop Left Join (cost=2.15..2,356.91 rows=48 width=393) (actual time=4.547..21.428 rows=106 loops=1)

65. 0.063 21.353 ↓ 2.2 106 1

Nested Loop Left Join (cost=1.73..2,334.98 rows=48 width=393) (actual time=4.540..21.353 rows=106 loops=1)

66. 0.268 20.866 ↓ 2.2 106 1

Nested Loop Left Join (cost=1.30..2,313.17 rows=48 width=294) (actual time=4.527..20.866 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.020 20.080 ↑ 1.0 100 1

Limit (cost=0.86..1,725.60 rows=100 width=174) (actual time=4.504..20.080 rows=100 loops=1)

68. 1.368 20.060 ↑ 31,715.9 100 1

Nested Loop Left Join (cost=0.86..54,701,323.58 rows=3,171,587 width=174) (actual time=4.503..20.060 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 (SubPlan 5))
  • Rows Removed by Filter: 1,193
69. 0.452 0.452 ↑ 18,095.1 304 1

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

70. 2.128 2.128 ↓ 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.005..0.007 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.500 0.500 ↑ 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.005..0.005 rows=1 loops=100)

  • Index Cond: (token_id = tokens.id)
  • Heap Fetches: 0
74. 2.552 15.312 ↓ 0.0 0 1,276

Bitmap Heap Scan on pronunciations pronunciations_4 (cost=4.64..6.88 rows=1 width=0) (actual time=0.012..0.012 rows=0 loops=1,276)

  • Recheck Cond: ((tokens.id = token_id) OR (lex_locale = 'en'::text) OR (lex_locale = 'und'::text))
  • Filter: (((tokens.id = token_id) AND (lex_locale = 'en-US'::text)) OR (lex_locale = 'en'::text) OR (lex_locale = 'und'::text))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=1,554
75. 0.000 12.760 ↓ 0.0 0 1,276

BitmapOr (cost=4.64..4.64 rows=2 width=0) (actual time=0.010..0.010 rows=0 loops=1,276)

76. 6.380 6.380 ↑ 1.0 2 1,276

Bitmap Index Scan on ix_pronunciations_token_id (cost=0.00..1.55 rows=2 width=0) (actual time=0.005..0.005 rows=2 loops=1,276)

  • Index Cond: (tokens.id = token_id)
77. 3.828 3.828 ↓ 0.0 0 1,276

Bitmap Index Scan on ix_pronunciations_lex_locale (cost=0.00..1.54 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1,276)

  • Index Cond: (lex_locale = 'en'::text)
78. 2.552 2.552 ↓ 0.0 0 1,276

Bitmap Index Scan on ix_pronunciations_lex_locale (cost=0.00..1.54 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1,276)

  • Index Cond: (lex_locale = 'und'::text)
79. 0.200 0.200 ↑ 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.002..0.002 rows=1 loops=100)

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

SubPlan (for Nested Loop Left Join)

81. 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)
82. 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)

83. 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
84. 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)
85. 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
86. 0.742 0.742 ↑ 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.006..0.007 rows=1 loops=106)

  • Index Cond: (tokens.id = token_id)
87. 0.742 0.742 ↑ 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.006..0.007 rows=1 loops=106)

  • Index Cond: (pronunciations.id = pronunciation_id)
88. 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)

89. 0.007 0.007 ↑ 1.0 14 1

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

90. 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)

91. 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)
92. 0.014 0.014 ↑ 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.007..0.007 rows=1 loops=2)

  • Index Cond: (id = proposed_token_actions_1.token_actions_id)
93. 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)
94. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_1.action_list_id)
95. 0.270 0.270 ↓ 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.002..0.002 rows=0 loops=135)

  • Index Cond: (id = token_states_1.last_action_id)
96. 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)
97. 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=375) (actual time=0.001..0.001 rows=0 loops=135)

  • Index Cond: (id = token_actions_2.action_list_id)
98. 0.675 0.675 ↑ 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.005..0.005 rows=1 loops=135)

  • Index Cond: (pronunciations.id = pron_id)
99. 0.000 0.405 ↓ 0.0 0 135

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

100. 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)
101. 0.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

  • Index Cond: (id = proposed_pron_actions_1.pron_actions_id)
102. 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)
103. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_1.action_list_id)
104. 0.675 0.675 ↑ 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.005..0.005 rows=1 loops=135)

  • Index Cond: (id = pron_states_1.last_action_id)
105. 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)
106. 0.405 0.405 ↑ 1.0 1 135

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

  • Index Cond: (id = pron_actions_2.action_list_id)
107. 0.000 0.000 ↓ 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.000..0.000 rows=0 loops=135)

  • Index Cond: (pronunciations.id = pronunciation_id)
108. 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)

109. 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)
110. 0.000 0.000 ↓ 0.0 0

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

111. 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)
112. 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)
113. 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)
114. 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)
115. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = script_actions_1.action_list_id)
116. 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)
117. 0.068 1.485 ↑ 1.0 1 135

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

118. 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.006..0.007 rows=1 loops=135)

  • Index Cond: (lexicon_data.id = lexicon_pron_occurrence_id)
119. 0.000 0.472 ↓ 0.0 0 118

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

120. 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)
121. 0.018 0.018 ↑ 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.009..0.009 rows=1 loops=2)

  • Index Cond: (id = proposed_lexicon_pron_occurrence_actions_1.lexicon_pron_occurrence_actions_id)
122. 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)
123. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = script_actions_2.action_list_id)
124. 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)
125. 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)
126. 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)
127. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_actions_1.action_list_id)
128. 0.405 0.405 ↓ 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.003..0.003 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_state_1.last_action_id)
129. 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)
130. 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=375) (actual time=0.001..0.001 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_actions_2.action_list_id)
131. 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)
132. 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)
133. 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)
134. 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)

135. 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)
136. 0.000 0.000 ↓ 0.0 0

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

137. 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)
138. 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)
139. 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)
140. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_3.action_list_id)
141. 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)
142. 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)
143. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_4.action_list_id)
144. 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)
145. 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)
146. 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)
147. 0.000 0.540 ↓ 0.0 0 135

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

148. 0.540 0.540 ↓ 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.004..0.004 rows=0 loops=135)

  • Index Cond: (tokens.id = token_id)
149. 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)
150. 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)

151. 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)
152. 0.000 0.000 ↓ 0.0 0

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

153. 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)
154. 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)
155. 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)
156. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_3.action_list_id)
157. 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)
158. 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)
159. 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)
160. 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)

161. 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)
162. 0.000 0.000 ↓ 0.0 0

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

163. 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)
164. 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)
165. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_4.action_list_id)
166. 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)
167. 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)
168. 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)
169. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_5.action_list_id)
170. 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)
171. 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)
172. 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=375) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_6.action_list_id)
173. 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)
174. 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 : 48.710 ms
Execution time : 43.159 ms