explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RbRg

Settings
# exclusive inclusive rows x rows loops node
1. 4.592 109.532 ↓ 0.0 0 1

Gather (cost=24,592.48..43,109.53 rows=1 width=17) (actual time=108.217..109.532 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.450 104.940 ↓ 0.0 0 3

Parallel Hash Join (cost=23,592.48..42,109.43 rows=1 width=17) (actual time=104.939..104.940 rows=0 loops=3)

  • Hash Cond: (m.id = a.id)
3. 43.741 43.741 ↑ 1.1 1,400 3

Parallel Seq Scan on movie m (cost=0.00..18,511.35 rows=1,491 width=21) (actual time=0.105..43.741 rows=1,400 loops=3)

  • Filter: (year > 2010)
  • Rows Removed by Filter: 511070
4. 0.046 60.749 ↓ 0.0 0 3

Parallel Hash (cost=23,592.46..23,592.46 rows=1 width=4) (actual time=60.749..60.749 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
5. 60.703 60.703 ↓ 0.0 0 3

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

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
Planning time : 0.227 ms
Execution time : 109.569 ms