explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O24E

Settings
# exclusive inclusive rows x rows loops node
1. 0.947 43.371 ↑ 2.3 135 1

Sort (cost=73,686.16..73,686.93 rows=305 width=9,786) (actual time=43.368..43.371 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
  • Buffers: shared hit=15,311
2. 0.180 42.424 ↑ 2.3 135 1

Hash Left Join (cost=1,119.67..73,673.58 rows=305 width=9,786) (actual time=11.449..42.424 rows=135 loops=1)

  • Hash Cond: (token_comments_3.creator_id = users_21.id)
  • Buffers: shared hit=15,311
3. 0.194 42.214 ↑ 2.3 135 1

Hash Left Join (cost=1,114.68..73,664.39 rows=305 width=9,740) (actual time=11.410..42.214 rows=135 loops=1)

  • Hash Cond: (tokens_1.id = token_comments_3.token_id)
  • Buffers: shared hit=15,309
4. 0.187 38.009 ↑ 2.3 135 1

Nested Loop Left Join (cost=722.81..73,242.40 rows=305 width=9,568) (actual time=7.391..38.009 rows=135 loops=1)

  • Buffers: shared hit=15,108
5. 0.191 37.822 ↑ 2.3 135 1

Nested Loop Left Join (cost=722.38..70,942.57 rows=305 width=9,216) (actual time=7.390..37.822 rows=135 loops=1)

  • Buffers: shared hit=15,108
6. 0.153 37.631 ↑ 2.3 135 1

Hash Left Join (cost=721.95..68,642.74 rows=305 width=8,864) (actual time=7.389..37.631 rows=135 loops=1)

  • Hash Cond: (token_actions_5.user_id = users_19.id)
  • Buffers: shared hit=15,108
7. 0.348 37.451 ↑ 2.3 135 1

Nested Loop Left Join (cost=716.96..68,633.56 rows=305 width=8,818) (actual time=7.353..37.451 rows=135 loops=1)

  • Buffers: shared hit=15,106
8. 0.150 36.833 ↑ 2.3 135 1

Hash Left Join (cost=709.41..67,452.14 rows=305 width=8,684) (actual time=7.341..36.833 rows=135 loops=1)

  • Hash Cond: (token_comments_2.creator_id = users_18.id)
  • Buffers: shared hit=15,106
9. 0.174 36.655 ↑ 2.3 135 1

Hash Left Join (cost=704.42..67,442.95 rows=305 width=8,638) (actual time=7.303..36.655 rows=135 loops=1)

  • Hash Cond: (tokens_2.id = token_comments_2.token_id)
  • Buffers: shared hit=15,104
10. 0.180 31.809 ↑ 2.3 135 1

Nested Loop Left Join (cost=312.55..67,020.96 rows=305 width=8,466) (actual time=2.621..31.809 rows=135 loops=1)

  • Buffers: shared hit=14,903
11. 0.237 31.629 ↑ 2.3 135 1

Nested Loop Left Join (cost=312.12..64,721.13 rows=305 width=8,114) (actual time=2.619..31.629 rows=135 loops=1)

  • Buffers: shared hit=14,903
12. 0.358 31.392 ↑ 2.3 135 1

Nested Loop Left Join (cost=310.53..55,539.09 rows=305 width=7,832) (actual time=2.618..31.392 rows=135 loops=1)

  • Buffers: shared hit=14,903
13. 0.149 30.359 ↑ 2.3 135 1

Hash Left Join (cost=269.03..54,323.72 rows=305 width=7,137) (actual time=2.597..30.359 rows=135 loops=1)

  • Hash Cond: (pron_actions_4.user_id = users_13.id)
  • Buffers: shared hit=14,903
14. 0.143 30.178 ↑ 2.3 135 1

Hash Left Join (cost=264.04..54,314.54 rows=305 width=7,091) (actual time=2.555..30.178 rows=135 loops=1)

  • Hash Cond: (pronunciation_comments_2.creator_id = users_14.id)
  • Buffers: shared hit=14,901
15. 0.289 29.993 ↑ 2.3 135 1

Nested Loop Left Join (cost=259.05..54,306.37 rows=305 width=7,045) (actual time=2.494..29.993 rows=135 loops=1)

  • Buffers: shared hit=14,899
16. 0.197 29.164 ↑ 1.7 135 1

Nested Loop Left Join (cost=251.65..53,394.52 rows=235 width=6,827) (actual time=2.477..29.164 rows=135 loops=1)

  • Buffers: shared hit=14,627
17. 0.142 28.967 ↑ 1.7 135 1

Hash Left Join (cost=251.22..51,406.42 rows=235 width=6,708) (actual time=2.475..28.967 rows=135 loops=1)

  • Hash Cond: (pronunciations_1.id = pronunciation_comments_2.pronunciation_id)
  • Buffers: shared hit=14,627
18. 0.150 28.825 ↑ 1.7 135 1

Nested Loop Left Join (cost=230.20..51,370.40 rows=235 width=6,572) (actual time=2.468..28.825 rows=135 loops=1)

  • Buffers: shared hit=14,627
19. 0.150 28.675 ↑ 1.7 135 1

Nested Loop Left Join (cost=229.77..49,598.43 rows=235 width=6,220) (actual time=2.466..28.675 rows=135 loops=1)

  • Buffers: shared hit=14,627
20. 0.143 28.525 ↑ 1.7 135 1

Nested Loop Left Join (cost=229.20..47,791.95 rows=235 width=6,118) (actual time=2.465..28.525 rows=135 loops=1)

  • Buffers: shared hit=14,627
21. 0.282 28.382 ↑ 1.7 135 1

Nested Loop Left Join (cost=228.77..46,019.98 rows=235 width=5,766) (actual time=2.463..28.382 rows=135 loops=1)

  • Buffers: shared hit=14,627
22. 0.120 27.830 ↑ 1.7 135 1

Hash Left Join (cost=198.29..45,085.04 rows=235 width=5,423) (actual time=2.453..27.830 rows=135 loops=1)

  • Hash Cond: (lexicon_data_comments_1.creator_id = users_11.id)
  • Buffers: shared hit=14,627
23. 0.108 27.681 ↑ 1.7 135 1

Hash Left Join (cost=193.30..45,077.60 rows=235 width=5,377) (actual time=2.416..27.681 rows=135 loops=1)

  • Hash Cond: (lexicon_data.id = lexicon_data_comments_1.lexicon_data_id)
  • Buffers: shared hit=14,625
24. 0.121 27.572 ↑ 1.7 135 1

Nested Loop Left Join (cost=172.27..45,041.59 rows=235 width=5,241) (actual time=2.407..27.572 rows=135 loops=1)

  • Buffers: shared hit=14,625
25. 0.181 27.316 ↑ 1.7 135 1

Nested Loop Left Join (cost=171.84..43,269.61 rows=235 width=4,889) (actual time=2.404..27.316 rows=135 loops=1)

  • Buffers: shared hit=14,409
26. 0.115 27.135 ↑ 1.7 135 1

Hash Left Join (cost=171.41..41,497.64 rows=235 width=4,537) (actual time=2.402..27.135 rows=135 loops=1)

  • Hash Cond: (lexicon_data_actions_1.user_id = users_9.id)
  • Buffers: shared hit=14,401
27. 0.276 26.979 ↑ 1.7 135 1

Nested Loop Left Join (cost=166.42..41,489.42 rows=235 width=4,491) (actual time=2.354..26.979 rows=135 loops=1)

  • Buffers: shared hit=14,399
28. 0.106 24.948 ↑ 1.7 135 1

Hash Left Join (cost=158.73..40,577.27 rows=235 width=4,330) (actual time=2.329..24.948 rows=135 loops=1)

  • Hash Cond: (script_comments_1.creator_id = users_8.id)
  • Buffers: shared hit=14,021
29. 0.096 24.815 ↑ 1.7 135 1

Hash Left Join (cost=153.74..40,569.84 rows=235 width=4,284) (actual time=2.293..24.815 rows=135 loops=1)

  • Hash Cond: (scripts.id = script_comments_1.script_id)
  • Buffers: shared hit=14,019
30. 0.117 24.719 ↑ 1.7 135 1

Nested Loop Left Join (cost=132.71..40,533.82 rows=235 width=4,148) (actual time=2.287..24.719 rows=135 loops=1)

  • Buffers: shared hit=14,019
31. 0.112 24.602 ↑ 1.7 135 1

Hash Left Join (cost=132.28..38,761.61 rows=235 width=3,796) (actual time=2.285..24.602 rows=135 loops=1)

  • Hash Cond: (script_actions_2.user_id = users_7.id)
  • Buffers: shared hit=14,019
32. 0.162 24.462 ↑ 1.7 135 1

Nested Loop Left Join (cost=127.29..38,753.39 rows=235 width=3,750) (actual time=2.248..24.462 rows=135 loops=1)

  • Buffers: shared hit=14,017
33. 0.129 23.085 ↑ 1.7 135 1

Nested Loop Left Join (cost=125.75..33,343.85 rows=235 width=3,560) (actual time=2.232..23.085 rows=135 loops=1)

  • Buffers: shared hit=13,056
34. 0.117 22.956 ↑ 1.7 135 1

Nested Loop Left Join (cost=125.32..31,573.15 rows=235 width=3,466) (actual time=2.231..22.956 rows=135 loops=1)

  • Buffers: shared hit=13,056
35. 0.112 22.839 ↑ 1.7 135 1

Hash Left Join (cost=124.89..29,800.94 rows=235 width=3,114) (actual time=2.230..22.839 rows=135 loops=1)

  • Hash Cond: (pronunciation_comments_1.creator_id = users_5.id)
  • Buffers: shared hit=13,056
36. 0.218 22.698 ↑ 1.7 135 1

Nested Loop Left Join (cost=119.90..29,793.50 rows=235 width=3,068) (actual time=2.192..22.698 rows=135 loops=1)

  • Buffers: shared hit=13,054
37. 0.103 22.210 ↑ 1.7 135 1

Hash Left Join (cost=97.44..28,866.58 rows=235 width=2,853) (actual time=2.184..22.210 rows=135 loops=1)

  • Hash Cond: (pronunciations.id = pronunciation_comments_1.pronunciation_id)
  • Buffers: shared hit=13,054
38. 0.067 22.107 ↑ 1.7 135 1

Nested Loop Left Join (cost=76.41..28,830.57 rows=235 width=2,717) (actual time=2.176..22.107 rows=135 loops=1)

  • Buffers: shared hit=13,054
39. 0.123 21.635 ↑ 1.7 135 1

Nested Loop Left Join (cost=75.98..27,058.59 rows=235 width=2,365) (actual time=2.169..21.635 rows=135 loops=1)

  • Buffers: shared hit=12,617
40. 0.274 21.512 ↑ 1.7 135 1

Nested Loop Left Join (cost=75.55..25,286.62 rows=235 width=2,013) (actual time=2.168..21.512 rows=135 loops=1)

  • Buffers: shared hit=12,613
41. 0.287 20.698 ↑ 1.7 135 1

Nested Loop Left Join (cost=60.17..24,366.78 rows=235 width=1,865) (actual time=2.154..20.698 rows=135 loops=1)

  • Buffers: shared hit=12,251
42. 0.119 17.171 ↑ 1.7 135 1

Nested Loop Left Join (cost=52.48..23,454.63 rows=235 width=1,717) (actual time=2.122..17.171 rows=135 loops=1)

  • Buffers: shared hit=11,488
43. 0.124 16.512 ↑ 1.7 135 1

Nested Loop Left Join (cost=52.05..21,680.03 rows=235 width=1,642) (actual time=2.113..16.512 rows=135 loops=1)

  • Buffers: shared hit=11,016
44. 0.130 16.253 ↑ 1.7 135 1

Nested Loop Left Join (cost=51.62..19,908.04 rows=235 width=1,290) (actual time=2.112..16.253 rows=135 loops=1)

  • Buffers: shared hit=10,764
45. 0.172 16.123 ↑ 1.7 135 1

Nested Loop Left Join (cost=51.19..18,136.04 rows=235 width=938) (actual time=2.111..16.123 rows=135 loops=1)

  • Buffers: shared hit=10,756
46. 0.290 15.276 ↑ 1.7 135 1

Nested Loop Left Join (cost=36.17..17,216.57 rows=235 width=804) (actual time=2.097..15.276 rows=135 loops=1)

  • Buffers: shared hit=10,471
47. 0.276 13.096 ↑ 1.7 135 1

Nested Loop Left Join (cost=28.62..16,304.56 rows=235 width=670) (actual time=2.086..13.096 rows=135 loops=1)

  • Buffers: shared hit=10,093
48. 0.082 11.548 ↑ 1.2 106 1

Nested Loop Left Join (cost=6.63..16,116.20 rows=127 width=470) (actual time=2.055..11.548 rows=106 loops=1)

  • Buffers: shared hit=9,534
49. 0.072 11.466 ↑ 1.2 106 1

Nested Loop Left Join (cost=6.20..15,159.31 rows=127 width=470) (actual time=2.052..11.466 rows=106 loops=1)

  • Buffers: shared hit=9,534
50. 0.469 11.076 ↑ 1.2 106 1

Nested Loop Left Join (cost=5.78..14,202.45 rows=127 width=370) (actual time=2.047..11.076 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[])))
  • Buffers: shared hit=9,267
51. 0.127 9.989 ↑ 1.0 100 1

Nested Loop Left Join (cost=1.30..8,258.76 rows=100 width=250) (actual time=2.021..9.989 rows=100 loops=1)

  • Buffers: shared hit=8,365
52. 0.022 9.362 ↑ 1.0 100 1

Limit (cost=0.86..7,411.76 rows=100 width=175) (actual time=2.015..9.362 rows=100 loops=1)

  • Buffers: shared hit=7,964
53. 0.187 9.340 ↑ 31,737.6 100 1

Nested Loop Left Join (cost=0.86..235,203,731.61 rows=3,173,756 width=175) (actual time=2.013..9.340 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,195
  • Buffers: shared hit=7,964
54. 0.239 0.239 ↑ 18,103.7 304 1

Index Scan Backward using descending_written_form on orthographies (cost=0.43..403,973.60 rows=5,503,516 width=56) (actual time=0.010..0.239 rows=304 loops=1)

  • Buffers: shared hit=308
55. 1.824 1.824 ↓ 4.0 4 304

Index Scan using ix_tokens_orthography_id on tokens (cost=0.43..0.51 rows=1 width=119) (actual time=0.005..0.006 rows=4 loops=304)

  • Index Cond: (orthographies.id = orthography_id)
  • Buffers: shared hit=1,471
56.          

SubPlan (for Nested Loop Left Join)

57. 0.200 0.200 ↑ 1.0 1 100

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

  • Index Cond: (orthography_id = orthographies.id)
  • Heap Fetches: 100
  • Buffers: shared hit=402
58. 0.500 0.500 ↑ 6.0 1 100

Index Only Scan using ix_pronunciations_token_id on pronunciations pronunciations_3 (cost=0.43..28.54 rows=6 width=0) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (token_id = tokens.id)
  • Heap Fetches: 83
  • Buffers: shared hit=383
59. 6.390 6.390 ↓ 0.0 0 1,278

Index Scan using ix_pronunciations_token_id on pronunciations pronunciations_4 (cost=0.43..28.56 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1,278)

  • Index Cond: (tokens.id = token_id)
  • Filter: (lex_locale = ANY ('{en-US,en,und}'::text[]))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=5,400
60. 0.500 0.500 ↑ 1.0 1 100

Index Scan using ix_token_states_token_id on token_states token_states_1 (cost=0.43..8.45 rows=1 width=75) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (tokens.id = token_id)
  • Buffers: shared hit=401
61. 0.100 0.300 ↑ 6.0 1 100

Bitmap Heap Scan on pronunciations (cost=4.48..28.45 rows=6 width=120) (actual time=0.003..0.003 rows=1 loops=100)

  • Recheck Cond: (tokens.id = token_id)
  • Heap Blocks: exact=89
  • Buffers: shared hit=389
62. 0.200 0.200 ↑ 6.0 1 100

Bitmap Index Scan on ix_pronunciations_token_id (cost=0.00..4.48 rows=6 width=0) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (tokens.id = token_id)
  • Buffers: shared hit=300
63.          

SubPlan (for Nested Loop Left Join)

64. 0.106 0.212 ↑ 5,756,739.0 1 106

Result (cost=0.00..124,408.39 rows=5,756,739 width=0) (actual time=0.002..0.002 rows=1 loops=106)

  • One-Time Filter: (orthographies.id = tokens.orthography_id)
  • Buffers: shared hit=106
65. 0.106 0.106 ↑ 5,756,739.0 1 106

Seq Scan on tokens tokens_3 (cost=0.00..124,408.39 rows=5,756,739 width=0) (actual time=0.001..0.001 rows=1 loops=106)

  • Buffers: shared hit=106
66. 0.106 0.106 ↑ 6.0 1 106

Index Only Scan using ix_pronunciations_token_id on pronunciations pronunciations_2 (cost=0.43..28.54 rows=6 width=0) (actual time=0.001..0.001 rows=1 loops=106)

  • Index Cond: (token_id = tokens.id)
  • Heap Fetches: 89
  • Buffers: shared hit=407
67. 0.318 0.318 ↓ 0.0 0 106

Index Scan using ix_scripts_pronunciation_id on scripts (cost=0.42..7.52 rows=1 width=100) (actual time=0.003..0.003 rows=0 loops=106)

  • Index Cond: (pronunciations.id = pronunciation_id)
  • Buffers: shared hit=267
68. 0.000 0.000 ↓ 0.0 0 106

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

  • Index Cond: (script_id = scripts.id)
  • Heap Fetches: 0
69. 0.547 1.272 ↑ 5.0 1 106

Hash Right Join (cost=21.99..23.25 rows=5 width=200) (actual time=0.009..0.012 rows=1 loops=106)

  • Hash Cond: (lexicons.id = lexicon_data.lexicon_id)
  • Buffers: shared hit=559
70. 0.089 0.089 ↓ 1.1 15 89

Seq Scan on lexicons (cost=0.00..1.14 rows=14 width=136) (actual time=0.000..0.001 rows=15 loops=89)

  • Buffers: shared hit=89
71. 0.106 0.636 ↑ 5.0 1 106

Hash (cost=21.93..21.93 rows=5 width=64) (actual time=0.006..0.006 rows=1 loops=106)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=470
72. 0.530 0.530 ↑ 5.0 1 106

Index Scan using ix_lexicon_data_pronunciation_id on lexicon_data (cost=0.56..21.93 rows=5 width=64) (actual time=0.005..0.005 rows=1 loops=106)

  • Index Cond: (pronunciations.id = pronunciation_id)
  • Buffers: shared hit=470
73. 0.981 1.890 ↓ 0.0 0 135

Hash Right Join (cost=7.55..11.39 rows=1 width=134) (actual time=0.009..0.014 rows=0 loops=135)

  • Hash Cond: (users_2.id = token_actions_2.user_id)
  • Buffers: shared hit=378
74. 0.504 0.504 ↑ 1.0 133 63

Seq Scan on users users_2 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.008 rows=133 loops=63)

  • Buffers: shared hit=126
75. 0.135 0.405 ↓ 0.0 0 135

Hash (cost=7.54..7.54 rows=1 width=88) (actual time=0.003..0.003 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=252
76. 0.270 0.270 ↓ 0.0 0 135

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

  • Index Cond: (id = token_states_1.last_action_id)
  • Buffers: shared hit=252
77. 0.256 0.675 ↓ 0.0 0 135

Hash Right Join (cost=15.02..18.85 rows=1 width=150) (actual time=0.005..0.005 rows=0 loops=135)

  • Hash Cond: (users_1.id = token_actions_1.user_id)
  • Buffers: shared hit=285
78. 0.014 0.014 ↑ 1.0 133 2

Seq Scan on users users_1 (cost=0.00..3.33 rows=133 width=46) (actual time=0.002..0.007 rows=133 loops=2)

  • Buffers: shared hit=4
79. 0.000 0.405 ↓ 0.0 0 135

Hash (cost=15.00..15.00 rows=1 width=104) (actual time=0.003..0.003 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
  • Buffers: shared hit=281
80. 0.131 0.405 ↓ 0.0 0 135

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

  • Buffers: shared hit=281
81. 0.270 0.270 ↓ 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..7.34 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=135)

  • Index Cond: (token_states_1.id = token_state_id)
  • Buffers: shared hit=273
82. 0.004 0.004 ↑ 1.0 1 2

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

  • Index Cond: (id = proposed_token_actions_1.token_actions_id)
  • Buffers: shared hit=8
83. 0.000 0.000 ↓ 0.0 0 135

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

  • Index Cond: (id = token_actions_1.action_list_id)
  • Buffers: shared hit=8
84. 0.135 0.135 ↓ 0.0 0 135

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

  • Index Cond: (id = token_actions_2.action_list_id)
  • Buffers: shared hit=252
85. 0.540 0.540 ↑ 1.0 1 135

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

  • Index Cond: (pronunciations.id = pron_id)
  • Buffers: shared hit=472
86. 1.584 3.240 ↑ 1.0 1 135

Hash Right Join (cost=7.69..11.53 rows=1 width=148) (actual time=0.012..0.024 rows=1 loops=135)

  • Hash Cond: (users_4.id = pron_actions_2.user_id)
  • Buffers: shared hit=763
87. 0.981 0.981 ↑ 1.0 133 109

Seq Scan on users users_4 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.009 rows=133 loops=109)

  • Buffers: shared hit=218
88. 0.135 0.675 ↑ 1.0 1 135

Hash (cost=7.68..7.68 rows=1 width=102) (actual time=0.005..0.005 rows=1 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=545
89. 0.540 0.540 ↑ 1.0 1 135

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

  • Index Cond: (id = pron_states_1.last_action_id)
  • Buffers: shared hit=545
90. 0.128 0.540 ↓ 0.0 0 135

Hash Right Join (cost=15.38..19.22 rows=1 width=164) (actual time=0.004..0.004 rows=0 loops=135)

  • Hash Cond: (users_3.id = pron_actions_1.user_id)
  • Buffers: shared hit=362
91. 0.007 0.007 ↑ 1.0 133 1

Seq Scan on users users_3 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.007 rows=133 loops=1)

  • Buffers: shared hit=2
92. 0.000 0.405 ↓ 0.0 0 135

Hash (cost=15.37..15.37 rows=1 width=118) (actual time=0.003..0.003 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
  • Buffers: shared hit=360
93. 0.132 0.405 ↓ 0.0 0 135

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

  • Buffers: shared hit=360
94. 0.270 0.270 ↓ 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..7.50 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=135)

  • Index Cond: (pron_states_1.id = pron_state_id)
  • Buffers: shared hit=355
95. 0.003 0.003 ↑ 1.0 1 1

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

  • Index Cond: (id = proposed_pron_actions_1.pron_actions_id)
  • Buffers: shared hit=5
96. 0.000 0.000 ↓ 0.0 0 135

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

  • Index Cond: (id = pron_actions_1.action_list_id)
  • Buffers: shared hit=4
97. 0.405 0.405 ↑ 1.0 1 135

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

  • Index Cond: (id = pron_actions_2.action_list_id)
  • Buffers: shared hit=437
98. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=14.90..14.90 rows=490 width=136) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
99. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on pronunciation_comments pronunciation_comments_1 (cost=0.00..14.90 rows=490 width=136) (actual time=0.000..0.000 rows=0 loops=1)

100. 0.135 0.270 ↓ 0.0 0 135

Hash Right Join (cost=22.46..26.30 rows=1 width=215) (actual time=0.002..0.002 rows=0 loops=135)

  • Hash Cond: (users_6.id = script_actions_1.user_id)
101. 0.000 0.000 ↓ 0.0 0

Seq Scan on users users_6 (cost=0.00..3.33 rows=133 width=46) (never executed)

102. 0.135 0.135 ↓ 0.0 0 135

Hash (cost=22.45..22.45 rows=1 width=169) (actual time=0.001..0.001 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
103. 0.000 0.000 ↓ 0.0 0 135

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

104. 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..7.52 rows=1 width=75) (actual time=0.000..0.000 rows=0 loops=135)

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

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

106. 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..7.36 rows=1 width=32) (never executed)

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

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

  • Index Cond: (id = proposed_script_actions_1.script_actions_id)
108. 0.021 0.029 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.029..0.029 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
109. 0.008 0.008 ↑ 1.0 133 1

Seq Scan on users users_5 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.008 rows=133 loops=1)

  • Buffers: shared hit=2
110. 0.000 0.000 ↓ 0.0 0 135

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

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

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

  • Index Cond: (id = script_states_1.last_action_id)
112. 0.068 1.215 ↑ 1.0 1 135

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

  • Buffers: shared hit=961
113. 0.675 0.675 ↑ 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..7.68 rows=1 width=75) (actual time=0.005..0.005 rows=1 loops=135)

  • Index Cond: (lexicon_data.id = lexicon_pron_occurrence_id)
  • Buffers: shared hit=594
114. 0.104 0.472 ↓ 0.0 0 118

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

  • Buffers: shared hit=367
115. 0.354 0.354 ↓ 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..7.50 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=118)

  • Index Cond: (lexicon_data_state_1.id = lexicon_pron_occurrence_state_id)
  • Buffers: shared hit=357
116. 0.014 0.014 ↑ 1.0 1 2

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

  • Index Cond: (id = proposed_lexicon_pron_occurrence_actions_1.lexicon_pron_occurrence_actions_id)
  • Buffers: shared hit=10
117. 0.021 0.028 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.028..0.028 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
118. 0.007 0.007 ↑ 1.0 133 1

Seq Scan on users users_7 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.007 rows=133 loops=1)

  • Buffers: shared hit=2
119. 0.000 0.000 ↓ 0.0 0 135

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

  • Index Cond: (id = script_actions_2.action_list_id)
120. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=14.90..14.90 rows=490 width=136) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
121. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on script_comments script_comments_1 (cost=0.00..14.90 rows=490 width=136) (actual time=0.000..0.000 rows=0 loops=1)

122. 0.017 0.027 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.027..0.027 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
123. 0.010 0.010 ↑ 1.0 133 1

Seq Scan on users users_8 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.010 rows=133 loops=1)

  • Buffers: shared hit=2
124. 0.918 1.755 ↓ 0.0 0 135

Hash Right Join (cost=7.69..11.53 rows=1 width=161) (actual time=0.008..0.013 rows=0 loops=135)

  • Hash Cond: (users_10.id = lexicon_data_actions_2.user_id)
  • Buffers: shared hit=378
125. 0.432 0.432 ↑ 1.0 133 54

Seq Scan on users users_10 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.008 rows=133 loops=54)

  • Buffers: shared hit=108
126. 0.135 0.405 ↓ 0.0 0 135

Hash (cost=7.68..7.68 rows=1 width=115) (actual time=0.003..0.003 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=270
127. 0.270 0.270 ↓ 0.0 0 135

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

  • Index Cond: (id = lexicon_data_state_1.last_action_id)
  • Buffers: shared hit=270
128. 0.034 0.041 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.041..0.041 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
129. 0.007 0.007 ↑ 1.0 133 1

Seq Scan on users users_9 (cost=0.00..3.33 rows=133 width=46) (actual time=0.002..0.007 rows=133 loops=1)

  • Buffers: shared hit=2
130. 0.000 0.000 ↓ 0.0 0 135

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

  • Index Cond: (id = lexicon_data_actions_1.action_list_id)
  • Buffers: shared hit=8
131. 0.135 0.135 ↓ 0.0 0 135

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

  • Index Cond: (id = lexicon_data_actions_2.action_list_id)
  • Buffers: shared hit=216
132. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=14.90..14.90 rows=490 width=136) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
133. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on lexicon_data_comments lexicon_data_comments_1 (cost=0.00..14.90 rows=490 width=136) (actual time=0.001..0.001 rows=0 loops=1)

134. 0.021 0.029 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.029..0.029 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
135. 0.008 0.008 ↑ 1.0 133 1

Seq Scan on users users_11 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.008 rows=133 loops=1)

  • Buffers: shared hit=2
136. 0.135 0.270 ↓ 0.0 0 135

Hash Right Join (cost=30.48..34.32 rows=1 width=343) (actual time=0.002..0.002 rows=0 loops=135)

  • Hash Cond: (users_12.id = pron_actions_3.user_id)
137. 0.000 0.000 ↓ 0.0 0

Seq Scan on users users_12 (cost=0.00..3.33 rows=133 width=46) (never executed)

138. 0.135 0.135 ↓ 0.0 0 135

Hash (cost=30.47..30.47 rows=1 width=297) (actual time=0.001..0.001 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
139. 0.000 0.000 ↓ 0.0 0 135

Nested Loop Left Join (cost=1.85..30.47 rows=1 width=297) (actual time=0.000..0.000 rows=0 loops=135)

140. 0.000 0.000 ↓ 0.0 0 135

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

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

Nested Loop Left Join (cost=1.41..22.92 rows=1 width=177) (never executed)

142. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pron_states_pron_id on pron_states pron_states_2 (cost=0.43..7.54 rows=1 width=75) (never executed)

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

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

144. 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..7.50 rows=1 width=32) (never executed)

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

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

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

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

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

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

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

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

  • Index Cond: (id = pron_actions_4.action_list_id)
149. 0.000 0.000 ↓ 0.0 0 1

Hash (cost=14.90..14.90 rows=490 width=136) (actual time=0.000..0.000 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
150. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on pronunciation_comments pronunciation_comments_2 (cost=0.00..14.90 rows=490 width=136) (actual time=0.000..0.000 rows=0 loops=1)

151. 0.000 0.000 ↓ 0.0 0 135

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

  • Index Cond: (id = tokens.original_id)
152. 0.270 0.540 ↓ 0.0 0 135

Hash Right Join (cost=7.40..11.23 rows=1 width=218) (actual time=0.004..0.004 rows=0 loops=135)

  • Hash Cond: (users_15.id = token_comments_1.creator_id)
  • Buffers: shared hit=272
153. 0.000 0.000 ↓ 0.0 0

Seq Scan on users users_15 (cost=0.00..3.33 rows=133 width=46) (never executed)

154. 0.000 0.270 ↓ 0.0 0 135

Hash (cost=7.38..7.38 rows=1 width=172) (actual time=0.002..0.002 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
  • Buffers: shared hit=272
155. 0.270 0.270 ↓ 0.0 0 135

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

  • Index Cond: (tokens.id = token_id)
  • Buffers: shared hit=272
156. 0.031 0.042 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.042..0.042 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
157. 0.011 0.011 ↑ 1.0 133 1

Seq Scan on users users_14 (cost=0.00..3.33 rows=133 width=46) (actual time=0.002..0.011 rows=133 loops=1)

  • Buffers: shared hit=2
158. 0.024 0.032 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.032..0.032 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
159. 0.008 0.008 ↑ 1.0 133 1

Seq Scan on users users_13 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.008 rows=133 loops=1)

  • Buffers: shared hit=2
160. 0.135 0.675 ↓ 0.0 0 135

Hash Right Join (cost=41.50..45.34 rows=1 width=695) (actual time=0.005..0.005 rows=0 loops=135)

  • Hash Cond: (users_17.id = token_actions_4.user_id)
161. 0.000 0.000 ↓ 0.0 0

Seq Scan on users users_17 (cost=0.00..3.33 rows=133 width=46) (never executed)

162. 0.135 0.540 ↓ 0.0 0 135

Hash (cost=41.49..41.49 rows=1 width=649) (actual time=0.004..0.004 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
163. 0.000 0.405 ↓ 0.0 0 135

Nested Loop Left Join (cost=23.42..41.49 rows=1 width=649) (actual time=0.003..0.003 rows=0 loops=135)

164. 0.135 0.405 ↓ 0.0 0 135

Nested Loop Left Join (cost=22.99..33.94 rows=1 width=561) (actual time=0.003..0.003 rows=0 loops=135)

165. 0.135 0.270 ↓ 0.0 0 135

Hash Right Join (cost=22.56..26.40 rows=1 width=209) (actual time=0.002..0.002 rows=0 loops=135)

  • Hash Cond: (users_16.id = token_actions_3.user_id)
166. 0.000 0.000 ↓ 0.0 0

Seq Scan on users users_16 (cost=0.00..3.33 rows=133 width=46) (never executed)

167. 0.135 0.135 ↓ 0.0 0 135

Hash (cost=22.55..22.55 rows=1 width=163) (actual time=0.001..0.001 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
168. 0.000 0.000 ↓ 0.0 0 135

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

169. 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..7.54 rows=1 width=75) (actual time=0.000..0.000 rows=0 loops=135)

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

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

171. 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..7.34 rows=1 width=32) (never executed)

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

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

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

Index Scan using action_lists_pkey on action_lists action_lists_11 (cost=0.43..7.53 rows=1 width=352) (never executed)

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

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

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

Nested Loop Left Join (cost=1.59..30.10 rows=1 width=282) (actual time=0.000..0.000 rows=0 loops=135)

176. 0.000 0.000 ↓ 0.0 0 135

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

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

Nested Loop Left Join (cost=1.15..22.55 rows=1 width=163) (never executed)

178. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_token_states_token_id on token_states token_states_3 (cost=0.43..7.54 rows=1 width=75) (never executed)

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

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

180. 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..7.34 rows=1 width=32) (never executed)

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

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

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

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

  • Index Cond: (id = token_actions_4.action_list_id)
183. 2.935 4.672 ↓ 1.0 8,488 1

Hash (cost=285.83..285.83 rows=8,483 width=172) (actual time=4.672..4.672 rows=8,488 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1,594kB
  • Buffers: shared hit=201
184. 1.737 1.737 ↓ 1.0 8,488 1

Seq Scan on token_comments token_comments_2 (cost=0.00..285.83 rows=8,483 width=172) (actual time=0.003..1.737 rows=8,488 loops=1)

  • Buffers: shared hit=201
185. 0.022 0.028 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.028..0.028 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
186. 0.006 0.006 ↑ 1.0 133 1

Seq Scan on users users_18 (cost=0.00..3.33 rows=133 width=46) (actual time=0.002..0.006 rows=133 loops=1)

  • Buffers: shared hit=2
187. 0.270 0.270 ↓ 0.0 0 135

Hash Right Join (cost=7.55..11.39 rows=1 width=134) (actual time=0.002..0.002 rows=0 loops=135)

  • Hash Cond: (users_20.id = token_actions_6.user_id)
188. 0.000 0.000 ↓ 0.0 0

Seq Scan on users users_20 (cost=0.00..3.33 rows=133 width=46) (never executed)

189. 0.000 0.000 ↓ 0.0 0 135

Hash (cost=7.54..7.54 rows=1 width=88) (actual time=0.000..0.000 rows=0 loops=135)

  • Buckets: 1,024 Batches: 1 Memory Usage: 0kB
190. 0.000 0.000 ↓ 0.0 0 135

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

  • Index Cond: (id = token_states_3.last_action_id)
191. 0.018 0.027 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.027..0.027 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
192. 0.009 0.009 ↑ 1.0 133 1

Seq Scan on users users_19 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.009 rows=133 loops=1)

  • Buffers: shared hit=2
193. 0.000 0.000 ↓ 0.0 0 135

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

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

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

  • Index Cond: (id = token_actions_6.action_list_id)
195. 2.807 4.011 ↓ 1.0 8,488 1

Hash (cost=285.83..285.83 rows=8,483 width=172) (actual time=4.011..4.011 rows=8,488 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1,594kB
  • Buffers: shared hit=201
196. 1.204 1.204 ↓ 1.0 8,488 1

Seq Scan on token_comments token_comments_3 (cost=0.00..285.83 rows=8,483 width=172) (actual time=0.002..1.204 rows=8,488 loops=1)

  • Buffers: shared hit=201
197. 0.020 0.030 ↑ 1.0 133 1

Hash (cost=3.33..3.33 rows=133 width=46) (actual time=0.030..0.030 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
198. 0.010 0.010 ↑ 1.0 133 1

Seq Scan on users users_21 (cost=0.00..3.33 rows=133 width=46) (actual time=0.001..0.010 rows=133 loops=1)

  • Buffers: shared hit=2
Planning time : 38.337 ms
Execution time : 47.834 ms