explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gvvh

Settings
# exclusive inclusive rows x rows loops node
1. 4.115 108.497 ↓ 5.0 5 1

Gather (cost=24,606.76..43,145.65 rows=1 width=17) (actual time=79.141..108.497 rows=5 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.743 104.382 ↓ 2.0 2 3

Parallel Hash Join (cost=23,606.76..42,145.55 rows=1 width=17) (actual time=83.400..104.382 rows=2 loops=3)

  • Hash Cond: (m.id = c.mid)
3. 43.520 43.520 ↑ 1.2 5,906 3

Parallel Seq Scan on movie m (cost=0.00..18,511.35 rows=7,314 width=21) (actual time=0.056..43.520 rows=5,906 loops=3)

  • Filter: (year >= 2010)
  • Rows Removed by Filter: 506565
4. 0.054 60.119 ↓ 89.5 179 3

Parallel Hash (cost=23,606.74..23,606.74 rows=2 width=4) (actual time=60.119..60.119 rows=179 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
5. 0.000 60.065 ↓ 89.5 179 3

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

6. 59.987 59.987 ↓ 0.0 0 3

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

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
7. 0.177 0.177 ↓ 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.070..0.177 rows=536 loops=1)

  • Index Cond: (pid = a.id)
Planning time : 0.643 ms