explain.depesz.com

PostgreSQL's explain analyze made readable

Result: txNj

Settings
# exclusive inclusive rows x rows loops node
1. 0.075 121.392 ↓ 5.0 5 1

Hash Join (cost=21,935.70..45,542.24 rows=1 width=17) (actual time=121.226..121.392 rows=5 loops=1)

  • Hash Cond: (c.mid = m.id)
2. 0.000 42.357 ↓ 89.3 536 1

Nested Loop (cost=1,000.43..24,606.95 rows=6 width=4) (actual time=42.201..42.357 rows=536 loops=1)

3. 0.000 42.273 ↑ 1.0 1 1

Gather (cost=1,000.00..24,592.56 rows=1 width=4) (actual time=42.186..42.273 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 56.790 56.790 ↓ 0.0 0 3

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

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

Index Scan using idx_pid on casts c (cost=0.43..12.59 rows=180 width=8) (actual time=0.009..0.101 rows=536 loops=1)

  • Index Cond: (pid = a.id)
6. 3.827 78.960 ↓ 1.4 17,717 1

Hash (cost=20,777.05..20,777.05 rows=12,657 width=21) (actual time=78.960..78.960 rows=17,717 loops=1)

  • Buckets: 32768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1202kB
7. 12.659 75.133 ↓ 1.4 17,717 1

Gather (cost=1,000.00..20,777.05 rows=12,657 width=21) (actual time=0.142..75.133 rows=17,717 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 62.474 62.474 ↓ 1.1 5,906 3

Parallel Seq Scan on movie m (cost=0.00..18,511.35 rows=5,274 width=21) (actual time=0.016..62.474 rows=5,906 loops=3)

  • Filter: (year >= 2010)
  • Rows Removed by Filter: 506565