explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wVw4

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.018 ↑ 1.0 10 1

Limit (cost=0.57..1.12 rows=10 width=37) (actual time=0.015..0.018 rows=10 loops=1)

2. 0.004 0.016 ↑ 546.2 10 1

Merge Join (cost=0.57..296.95 rows=5,462 width=37) (actual time=0.014..0.016 rows=10 loops=1)

  • Merge Cond: (a.actor_id = fa.actor_id)
3. 0.005 0.005 ↑ 100,200.0 1 1

Index Scan using actor_pkey on actor a (cost=0.29..3,326.29 rows=100,200 width=25) (actual time=0.005..0.005 rows=1 loops=1)

4. 0.007 0.007 ↑ 546.2 10 1

Index Scan using film_actor_pkey on film_actor fa (cost=0.28..221.28 rows=5,462 width=12) (actual time=0.005..0.007 rows=10 loops=1)

Planning time : 0.209 ms
Execution time : 0.048 ms