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. 0.048 62.938 ↓ 2.0 2 3 / 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.023 60.567 ↓ 89.5 179 3 / 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 / 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: 621,678
5. 0.056 0.056 ↓ 3.0 536 1 / 3

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. 2.323 2.323 ↓ 0.0 0 536 / 3

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 >= 2,010)
  • Rows Removed by Filter: 1