explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1cVa

Settings
# exclusive inclusive rows x rows loops node
1. 4.915 67.853 ↓ 5.0 5 1

Gather (cost=1,000.86..24,607.76 rows=1 width=17) (actual time=65.775..67.853 rows=5 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2.358 62.938 ↓ 2.0 2 3

Nested Loop (cost=0.86..23,607.66 rows=1 width=17) (actual time=47.633..62.938 rows=2 loops=3)

3. 0.000 60.567 ↓ 89.5 179 3

Nested Loop (cost=0.43..23,606.74 rows=2 width=4) (actual time=47.306..60.567 rows=179 loops=3)

4. 60.488 60.488 ↓ 0.0 0 3

Parallel Seq Scan on actor a (cost=0.00..23,592.46 rows=1 width=4) (actual time=47.291..60.488 rows=0 loops=3)

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
5. 0.168 0.168 ↓ 3.0 536 1

Index Scan using index_casts_pid on casts c (cost=0.43..12.52 rows=176 width=8) (actual time=0.038..0.168 rows=536 loops=1)

  • Index Cond: (pid = a.id)
6. 0.013 0.013 ↓ 0.0 0 536

Index Scan using index_movie_id on movie m (cost=0.43..0.45 rows=1 width=21) (actual time=0.013..0.013 rows=0 loops=536)

  • Index Cond: (id = c.mid)
  • Filter: (year >= 2010)
  • Rows Removed by Filter: 1