# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 121,625.369 | 121,936.545 | ↓ 785.0 | 785 | 1 |
→
Nested Loop (cost=0.87..957.82 rows=1 width=54) (actual time=78.007..121,936.545 rows=785 loops=1)
|
2. | 6.886 | 6.886 | ↓ 26.2 | 315 | 1 |
→
Index Scan using theme_entry_theme_id on theme_entry txt_te (cost=0.43..478.00 rows=12 width=540) (actual time=0.057..6.886 rows=315 loops=1)
|
3. | 290.153 | 304.290 | ↓ 266.1 | 2,661 | 315 |
→
Materialize (cost=0.43..477.44 rows=10 width=54) (actual time=0.000..0.966 rows=2,661 loops=315) |
4. | 14.137 | 14.137 | ↓ 266.1 | 2,661 | 1 |
→
Index Scan using theme_entry_theme_id on theme_entry img_te (cost=0.43..477.39 rows=10 width=54) (actual time=0.024..14.137 rows=2,661 loops=1)
|
Planning time | : | 0.239 ms |
---|---|---|
Execution time | : | 121,937.167 ms |