explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rYOh

Settings
# exclusive inclusive rows x rows loops node
1. 0.767 631.950 ↑ 2.3 135 1

Sort (cost=13,939.28..13,940.05 rows=308 width=6,229) (actual time=631.945..631.950 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=40,291
2. 0.230 631.183 ↑ 2.3 135 1

Nested Loop Left Join (cost=28.21..13,926.55 rows=308 width=6,229) (actual time=609.830..631.183 rows=135 loops=1)

  • Buffers: shared hit=40,291
3. 0.228 630.953 ↑ 2.3 135 1

Nested Loop Left Join (cost=28.06..13,876.37 rows=308 width=6,183) (actual time=609.820..630.953 rows=135 loops=1)

  • Buffers: shared hit=40,291
4. 0.217 630.725 ↑ 2.3 135 1

Nested Loop Left Join (cost=27.78..13,780.11 rows=308 width=6,011) (actual time=609.810..630.725 rows=135 loops=1)

  • Buffers: shared hit=40,291
5. 0.219 630.508 ↑ 2.3 135 1

Nested Loop Left Join (cost=27.35..13,640.42 rows=308 width=5,909) (actual time=609.802..630.508 rows=135 loops=1)

  • Buffers: shared hit=40,291
6. 0.214 630.289 ↑ 2.3 135 1

Nested Loop Left Join (cost=27.20..13,590.41 rows=308 width=5,863) (actual time=609.793..630.289 rows=135 loops=1)

  • Buffers: shared hit=40,291
7. 0.217 630.075 ↑ 2.3 135 1

Nested Loop Left Join (cost=26.77..13,444.00 rows=308 width=5,775) (actual time=609.783..630.075 rows=135 loops=1)

  • Buffers: shared hit=40,291
8. 0.210 629.858 ↑ 2.3 135 1

Nested Loop Left Join (cost=26.34..13,304.32 rows=308 width=5,673) (actual time=609.772..629.858 rows=135 loops=1)

  • Buffers: shared hit=40,291
9. 0.208 629.648 ↑ 2.3 135 1

Nested Loop Left Join (cost=26.20..13,254.30 rows=308 width=5,627) (actual time=609.764..629.648 rows=135 loops=1)

  • Buffers: shared hit=40,291
10. 0.224 629.440 ↑ 2.3 135 1

Nested Loop Left Join (cost=26.05..13,204.13 rows=308 width=5,581) (actual time=609.754..629.440 rows=135 loops=1)

  • Buffers: shared hit=40,291
11. 0.209 629.216 ↑ 2.3 135 1

Nested Loop Left Join (cost=25.77..13,107.87 rows=308 width=5,409) (actual time=609.745..629.216 rows=135 loops=1)

  • Buffers: shared hit=40,291
12. 0.245 629.007 ↑ 2.3 135 1

Nested Loop Left Join (cost=25.34..12,968.18 rows=308 width=5,307) (actual time=609.737..629.007 rows=135 loops=1)

  • Buffers: shared hit=40,291
13. 0.212 628.762 ↑ 2.3 135 1

Nested Loop Left Join (cost=24.18..12,075.42 rows=308 width=5,144) (actual time=609.728..628.762 rows=135 loops=1)

  • Buffers: shared hit=40,291
14. 0.200 628.550 ↑ 2.3 135 1

Nested Loop Left Join (cost=23.75..11,931.55 rows=308 width=5,025) (actual time=609.719..628.550 rows=135 loops=1)

  • Buffers: shared hit=40,291
15. 0.199 628.350 ↑ 2.3 135 1

Nested Loop Left Join (cost=23.61..11,881.53 rows=308 width=4,979) (actual time=609.708..628.350 rows=135 loops=1)

  • Buffers: shared hit=40,291
16. 0.197 628.151 ↑ 2.3 135 1

Nested Loop Left Join (cost=23.17..11,735.13 rows=308 width=4,891) (actual time=609.699..628.151 rows=135 loops=1)

  • Buffers: shared hit=40,291
17. 0.204 627.954 ↑ 2.3 135 1

Nested Loop Left Join (cost=22.74..11,595.45 rows=308 width=4,789) (actual time=609.691..627.954 rows=135 loops=1)

  • Buffers: shared hit=40,291
18. 0.247 627.750 ↑ 2.3 135 1

Nested Loop Left Join (cost=22.60..11,545.43 rows=308 width=4,743) (actual time=609.680..627.750 rows=135 loops=1)

  • Buffers: shared hit=40,291
19. 0.138 627.503 ↑ 2.3 135 1

Nested Loop Left Join (cost=21.45..10,652.67 rows=308 width=4,580) (actual time=609.671..627.503 rows=135 loops=1)

  • Buffers: shared hit=40,291
20. 0.189 626.960 ↑ 1.8 135 1

Nested Loop Left Join (cost=21.02..10,237.50 rows=237 width=4,362) (actual time=609.654..626.960 rows=135 loops=1)

  • Buffers: shared hit=40,019
21. 0.181 626.771 ↑ 1.8 135 1

Nested Loop Left Join (cost=20.58..9,607.23 rows=237 width=4,243) (actual time=609.646..626.771 rows=135 loops=1)

  • Buffers: shared hit=40,019
22. 0.177 626.590 ↑ 1.8 135 1

Nested Loop Left Join (cost=20.44..9,566.61 rows=237 width=4,197) (actual time=609.636..626.590 rows=135 loops=1)

  • Buffers: shared hit=40,019
23. 0.174 626.413 ↑ 1.8 135 1

Nested Loop Left Join (cost=20.29..9,518.62 rows=237 width=4,061) (actual time=609.628..626.413 rows=135 loops=1)

  • Buffers: shared hit=40,019
24. 0.173 626.239 ↑ 1.8 135 1

Nested Loop Left Join (cost=19.86..9,412.06 rows=237 width=3,959) (actual time=609.621..626.239 rows=135 loops=1)

  • Buffers: shared hit=40,019
25. 0.178 626.066 ↑ 1.8 135 1

Nested Loop Left Join (cost=19.72..9,373.58 rows=237 width=3,913) (actual time=609.613..626.066 rows=135 loops=1)

  • Buffers: shared hit=40,019
26. 0.175 625.888 ↑ 1.8 135 1

Nested Loop Left Join (cost=19.15..9,225.15 rows=237 width=3,812) (actual time=609.605..625.888 rows=135 loops=1)

  • Buffers: shared hit=40,019
27. 0.176 625.713 ↑ 1.8 135 1

Nested Loop Left Join (cost=18.72..9,118.58 rows=237 width=3,710) (actual time=609.597..625.713 rows=135 loops=1)

  • Buffers: shared hit=40,019
28. 0.216 625.537 ↑ 1.8 135 1

Nested Loop Left Join (cost=18.58..9,080.11 rows=237 width=3,664) (actual time=609.588..625.537 rows=135 loops=1)

  • Buffers: shared hit=40,019
29. 0.176 625.321 ↑ 1.8 135 1

Nested Loop Left Join (cost=17.17..8,298.31 rows=237 width=3,488) (actual time=609.577..625.321 rows=135 loops=1)

  • Buffers: shared hit=40,019
30. 0.167 625.145 ↑ 1.8 135 1

Nested Loop Left Join (cost=16.73..8,185.39 rows=237 width=3,368) (actual time=609.567..625.145 rows=135 loops=1)

  • Buffers: shared hit=40,019
31. 0.219 624.978 ↑ 1.8 135 1

Nested Loop Left Join (cost=16.59..8,144.77 rows=237 width=3,322) (actual time=609.560..624.978 rows=135 loops=1)

  • Buffers: shared hit=40,019
32. 0.152 624.759 ↑ 1.8 135 1

Nested Loop Left Join (cost=16.44..8,096.78 rows=237 width=3,186) (actual time=609.550..624.759 rows=135 loops=1)

  • Buffers: shared hit=39,901
33. 0.088 624.472 ↑ 1.8 135 1

Nested Loop Left Join (cost=16.01..7,990.26 rows=237 width=3,084) (actual time=609.538..624.472 rows=135 loops=1)

  • Buffers: shared hit=39,685
34. 0.139 624.249 ↑ 1.8 135 1

Nested Loop Left Join (cost=15.86..7,951.79 rows=237 width=3,038) (actual time=609.524..624.249 rows=135 loops=1)

  • Buffers: shared hit=39,577
35. 0.158 623.705 ↑ 1.8 135 1

Nested Loop Left Join (cost=15.30..7,807.17 rows=237 width=2,923) (actual time=609.505..623.705 rows=135 loops=1)

  • Buffers: shared hit=39,307
36. 0.149 623.547 ↑ 1.8 135 1

Nested Loop Left Join (cost=14.87..7,700.66 rows=237 width=2,821) (actual time=609.497..623.547 rows=135 loops=1)

  • Buffers: shared hit=39,299
37. 0.141 623.398 ↑ 1.8 135 1

Nested Loop Left Join (cost=14.73..7,662.18 rows=237 width=2,775) (actual time=609.490..623.398 rows=135 loops=1)

  • Buffers: shared hit=39,295
38. 0.154 623.257 ↑ 1.8 135 1

Nested Loop Left Join (cost=14.58..7,621.56 rows=237 width=2,729) (actual time=609.481..623.257 rows=135 loops=1)

  • Buffers: shared hit=39,295
39. 0.146 623.103 ↑ 1.8 135 1

Nested Loop Left Join (cost=14.43..7,573.57 rows=237 width=2,593) (actual time=609.473..623.103 rows=135 loops=1)

  • Buffers: shared hit=39,295
40. 0.162 622.957 ↑ 1.8 135 1

Nested Loop Left Join (cost=14.00..7,457.69 rows=237 width=2,491) (actual time=609.467..622.957 rows=135 loops=1)

  • Buffers: shared hit=39,295
41. 0.198 622.795 ↑ 1.8 135 1

Nested Loop Left Join (cost=13.86..7,419.21 rows=237 width=2,445) (actual time=609.459..622.795 rows=135 loops=1)

  • Buffers: shared hit=39,295
42. 0.139 621.247 ↑ 1.8 135 1

Nested Loop Left Join (cost=12.32..6,637.50 rows=237 width=2,255) (actual time=609.427..621.247 rows=135 loops=1)

  • Buffers: shared hit=38,334
43. 0.133 621.108 ↑ 1.8 135 1

Nested Loop Left Join (cost=11.89..6,527.20 rows=237 width=2,161) (actual time=609.418..621.108 rows=135 loops=1)

  • Buffers: shared hit=38,334
44. 0.138 620.975 ↑ 1.8 135 1

Nested Loop Left Join (cost=11.46..6,411.33 rows=237 width=2,059) (actual time=609.411..620.975 rows=135 loops=1)

  • Buffers: shared hit=38,334
45. 0.135 620.837 ↑ 1.8 135 1

Nested Loop Left Join (cost=11.32..6,372.85 rows=237 width=2,013) (actual time=609.404..620.837 rows=135 loops=1)

  • Buffers: shared hit=38,334
46. 0.170 620.702 ↑ 1.8 135 1

Nested Loop Left Join (cost=11.17..6,332.23 rows=237 width=1,967) (actual time=609.398..620.702 rows=135 loops=1)

  • Buffers: shared hit=38,334
47. 0.182 620.532 ↑ 1.8 135 1

Nested Loop Left Join (cost=10.03..5,857.54 rows=237 width=1,798) (actual time=609.391..620.532 rows=135 loops=1)

  • Buffers: shared hit=38,334
48. 0.120 620.350 ↑ 1.8 135 1

Nested Loop Left Join (cost=9.89..5,809.54 rows=237 width=1,662) (actual time=609.379..620.350 rows=135 loops=1)

  • Buffers: shared hit=38,216
49. 0.112 619.825 ↑ 1.8 135 1

Nested Loop Left Join (cost=9.46..5,702.98 rows=237 width=1,560) (actual time=609.366..619.825 rows=135 loops=1)

  • Buffers: shared hit=37,780
50. 0.059 619.578 ↑ 1.8 135 1

Nested Loop Left Join (cost=9.31..5,664.50 rows=237 width=1,514) (actual time=609.353..619.578 rows=135 loops=1)

  • Buffers: shared hit=37,562
51. 0.116 618.844 ↑ 1.8 135 1

Nested Loop Left Join (cost=8.75..5,516.07 rows=237 width=1,413) (actual time=609.340..618.844 rows=135 loops=1)

  • Buffers: shared hit=37,017
52. 0.122 618.728 ↑ 1.8 135 1

Nested Loop Left Join (cost=8.32..5,409.51 rows=237 width=1,311) (actual time=609.337..618.728 rows=135 loops=1)

  • Buffers: shared hit=37,013
53. 0.114 618.606 ↑ 1.8 135 1

Nested Loop Left Join (cost=8.17..5,371.03 rows=237 width=1,265) (actual time=609.327..618.606 rows=135 loops=1)

  • Buffers: shared hit=37,011
54. 0.069 618.087 ↑ 1.8 135 1

Nested Loop Left Join (cost=7.20..4,703.11 rows=237 width=1,164) (actual time=609.316..618.087 rows=135 loops=1)

  • Buffers: shared hit=36,651
55. 0.140 617.343 ↑ 1.8 135 1

Nested Loop Left Join (cost=6.76..4,589.23 rows=237 width=1,089) (actual time=609.304..617.343 rows=135 loops=1)

  • Buffers: shared hit=36,179
56. 0.047 617.068 ↑ 1.8 135 1

Nested Loop Left Join (cost=6.33..4,481.74 rows=237 width=987) (actual time=609.300..617.068 rows=135 loops=1)

  • Buffers: shared hit=35,927
57. 0.166 616.886 ↑ 1.8 135 1

Nested Loop Left Join (cost=6.19..4,443.27 rows=237 width=941) (actual time=609.298..616.886 rows=135 loops=1)

  • Buffers: shared hit=35,801
58. 0.113 616.450 ↑ 1.8 135 1

Nested Loop Left Join (cost=5.75..4,330.61 rows=237 width=853) (actual time=609.292..616.450 rows=135 loops=1)

  • Buffers: shared hit=35,549
59. 0.105 616.337 ↑ 1.8 135 1

Nested Loop Left Join (cost=5.32..4,223.13 rows=237 width=751) (actual time=609.289..616.337 rows=135 loops=1)

  • Buffers: shared hit=35,541
60. 0.088 616.232 ↑ 1.8 135 1

Nested Loop Left Join (cost=5.18..4,184.65 rows=237 width=705) (actual time=609.285..616.232 rows=135 loops=1)

  • Buffers: shared hit=35,537
61. 0.102 615.739 ↑ 1.8 135 1

Hash Left Join (cost=4.46..3,610.95 rows=237 width=617) (actual time=609.275..615.739 rows=135 loops=1)

  • Hash Cond: (lexicon_data.lexicon_id = lexicons.id)
  • Buffers: shared hit=35,256
62. 0.108 615.624 ↑ 1.8 135 1

Nested Loop Left Join (cost=3.14..3,608.83 rows=237 width=533) (actual time=609.248..615.624 rows=135 loops=1)

  • Buffers: shared hit=35,255
63. 0.080 614.880 ↑ 1.2 106 1

Nested Loop Left Join (cost=2.58..3,512.27 rows=128 width=469) (actual time=609.231..614.880 rows=106 loops=1)

  • Buffers: shared hit=34,785
64. 0.029 614.800 ↑ 1.2 106 1

Nested Loop Left Join (cost=2.16..3,453.81 rows=128 width=469) (actual time=609.228..614.800 rows=106 loops=1)

  • Buffers: shared hit=34,785
65. 0.276 614.347 ↑ 1.2 106 1

Nested Loop Left Join (cost=1.73..3,395.63 rows=128 width=370) (actual time=609.216..614.347 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=34,518
66. 0.100 613.453 ↑ 1.0 100 1

Nested Loop Left Join (cost=1.30..2,164.01 rows=100 width=250) (actual time=609.191..613.453 rows=100 loops=1)

  • Buffers: shared hit=33,682
67. 0.020 612.753 ↑ 1.0 100 1

Limit (cost=0.86..1,897.01 rows=100 width=175) (actual time=609.179..612.753 rows=100 loops=1)

  • Buffers: shared hit=33,281
68. 332.247 612.733 ↑ 31,815.4 100 1

Nested Loop Left Join (cost=0.86..60,326,748.10 rows=3,181,541 width=175) (actual time=609.178..612.733 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
  • Buffers: shared hit=33,281
69. 0.334 0.334 ↑ 18,098.2 304 1

Index Scan Backward using descending_written_form on orthographies (cost=0.43..171,553.52 rows=5,501,859 width=56) (actual time=0.013..0.334 rows=304 loops=1)

  • Buffers: shared hit=309
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=119) (actual time=0.005..0.007 rows=4 loops=304)

  • Index Cond: (orthographies.id = orthography_id)
  • Buffers: shared hit=1,470
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
  • Buffers: shared hit=305
73. 0.500 0.500 ↑ 6.0 1 100

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

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

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

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

Bitmap Heap Scan on pronunciations pronunciations_5 (cost=12,990.60..200,882.86 rows=1,222,128 width=16) (actual time=80.725..277.224 rows=1,200,525 loops=1)

  • Recheck Cond: (lex_locale = ANY ('{en-US,en,und}'::text[]))
  • Heap Blocks: exact=27,585
  • Buffers: shared hit=30,874
76. 77.378 77.378 ↑ 1.0 1,200,525 1

Bitmap Index Scan on ix_pronunciations_lex_locale (cost=0.00..12,685.06 rows=1,222,128 width=0) (actual time=77.378..77.378 rows=1,200,525 loops=1)

  • Index Cond: (lex_locale = ANY ('{en-US,en,und}'::text[]))
  • Buffers: shared hit=3,289
77. 0.600 0.600 ↑ 1.0 1 100

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.006 rows=1 loops=100)

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

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

  • Index Cond: (tokens.id = token_id)
  • Buffers: shared hit=389
79.          

SubPlan (for Nested Loop Left Join)

80. 0.000 0.106 ↑ 5,754,067.0 1 106

Result (cost=0.00..124,347.67 rows=5,754,067 width=0) (actual time=0.001..0.001 rows=1 loops=106)

  • One-Time Filter: (orthographies.id = tokens.orthography_id)
  • Buffers: shared hit=106
81. 0.106 0.106 ↑ 5,754,067.0 1 106

Seq Scan on tokens tokens_3 (cost=0.00..124,347.67 rows=5,754,067 width=0) (actual time=0.001..0.001 rows=1 loops=106)

  • Buffers: shared hit=106
82. 0.212 0.212 ↑ 6.0 1 106

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

  • Index Cond: (token_id = tokens.id)
  • Heap Fetches: 0
  • Buffers: shared hit=341
83. 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)
  • Buffers: shared hit=267
84. 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
85. 0.636 0.636 ↑ 6.0 1 106

Index Scan using ix_lexicon_data_pronunciation_id on lexicon_data (cost=0.56..0.69 rows=6 width=64) (actual time=0.006..0.006 rows=1 loops=106)

  • Index Cond: (pronunciations.id = pronunciation_id)
  • Buffers: shared hit=470
86. 0.005 0.013 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=84) (actual time=0.013..0.013 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
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)

  • Buffers: shared hit=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)

  • Buffers: shared hit=281
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)
  • Buffers: shared hit=273
90. 0.016 0.016 ↑ 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.008..0.008 rows=1 loops=2)

  • Index Cond: (id = proposed_token_actions_1.token_actions_id)
  • Buffers: shared hit=8
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)
  • Buffers: shared hit=4
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=102) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = token_actions_1.action_list_id)
  • Buffers: shared hit=8
93. 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)
  • Buffers: shared hit=252
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)
  • Buffers: shared hit=126
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=102) (actual time=0.001..0.001 rows=0 loops=135)

  • Index Cond: (id = token_actions_2.action_list_id)
  • Buffers: shared hit=252
96. 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.004..0.005 rows=1 loops=135)

  • Index Cond: (pronunciations.id = pron_id)
  • Buffers: shared hit=472
97. 0.000 0.405 ↓ 0.0 0 135

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

  • Buffers: shared hit=360
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)
  • Buffers: shared hit=355
99. 0.013 0.013 ↑ 1.0 1 1

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

  • Index Cond: (id = proposed_pron_actions_1.pron_actions_id)
  • Buffers: shared hit=5
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)
  • Buffers: shared hit=2
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=102) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = pron_actions_1.action_list_id)
  • Buffers: shared hit=4
102. 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=101) (actual time=0.005..0.005 rows=1 loops=135)

  • Index Cond: (id = pron_states_1.last_action_id)
  • Buffers: shared hit=545
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)
  • Buffers: shared hit=218
104. 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=102) (actual time=0.003..0.003 rows=1 loops=135)

  • Index Cond: (id = pron_actions_2.action_list_id)
  • Buffers: shared hit=436
105. 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)
  • Buffers: shared hit=118
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=102) (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.068 1.350 ↑ 1.0 1 135

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

  • Buffers: shared hit=961
116. 0.810 0.810 ↑ 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.006 rows=1 loops=135)

  • Index Cond: (lexicon_data.id = lexicon_pron_occurrence_id)
  • Buffers: shared hit=594
117. 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)

  • Buffers: shared hit=367
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)
  • Buffers: shared hit=357
119. 0.022 0.022 ↑ 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.011..0.011 rows=1 loops=2)

  • Index Cond: (id = proposed_lexicon_pron_occurrence_actions_1.lexicon_pron_occurrence_actions_id)
  • Buffers: shared hit=10
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=102) (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)
  • Buffers: shared hit=4
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=102) (actual time=0.000..0.000 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_actions_1.action_list_id)
  • Buffers: shared hit=8
126. 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)
  • Buffers: shared hit=270
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)
  • Buffers: shared hit=108
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=102) (actual time=0.001..0.001 rows=0 loops=135)

  • Index Cond: (id = lexicon_data_actions_2.action_list_id)
  • Buffers: shared hit=216
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)
  • Buffers: shared hit=118
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=176) (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=117) (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=101) (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=102) (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=101) (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=102) (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=119) (actual time=0.000..0.000 rows=0 loops=135)

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

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

  • Buffers: shared hit=272
146. 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..1.58 rows=1 width=172) (actual time=0.002..0.002 rows=0 loops=135)

  • Index Cond: (tokens.id = token_id)
  • Buffers: shared hit=272
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=102) (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=119) (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=102) (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=102) (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=102) (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 : 45.602 ms
Execution time : 638.298 ms