# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.310 | 2.794 | ↓ 5.0 | 5 | 1 |
→
Nested Loop (cost=1.29..25.61 rows=1 width=17) (actual time=0.429..2.794 rows=5 loops=1) |
2. | 0.112 | 0.340 | ↓ 89.3 | 536 | 1 |
→
Nested Loop (cost=0.86..22.83 rows=6 width=4) (actual time=0.038..0.340 rows=536 loops=1) |
3. | 0.026 | 0.026 | ↑ 1.0 | 1 | 1 |
→
Index Scan using idx_name on actor a (cost=0.43..8.45 rows=1 width=4) (actual time=0.025..0.026 rows=1 loops=1)
|
4. | 0.202 | 0.202 | ↓ 3.0 | 536 | 1 |
→
Index Scan using index_actor on casts c (cost=0.43..12.59 rows=180 width=8) (actual time=0.009..0.202 rows=536 loops=1)
|
5. | 2.144 | 2.144 | ↓ 0.0 | 0 | 536 |
→
Index Scan using idx_mid on movie m (cost=0.43..0.45 rows=1 width=21) (actual time=0.004..0.004 rows=0 loops=536)
|