explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LjwC

Settings
# exclusive inclusive rows x rows loops node
1. 113.749 258.182 ↑ 1.0 1 1

Nested Loop (cost=2,000.43..44,215.59 rows=1 width=17) (actual time=164.468..258.182 rows=1 loops=1)

  • Join Filter: (b.mid = a.id)
  • Rows Removed by Join Filter: 2251735
2. 0.000 1.599 ↓ 8.2 4,201 1

Gather (cost=1,000.00..19,562.55 rows=512 width=21) (actual time=0.298..1.599 rows=4,201 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 44.957 44.957 ↓ 6.6 1,400 3

Parallel Seq Scan on movie a (cost=0.00..18,511.35 rows=213 width=21) (actual time=0.033..44.957 rows=1,400 loops=3)

  • Filter: (year > 2010)
  • Rows Removed by Filter: 511070
4. 74.841 142.834 ↓ 89.3 536 4,201

Materialize (cost=1,000.43..24,606.98 rows=6 width=4) (actual time=0.016..0.034 rows=536 loops=4,201)

5. 0.044 67.993 ↓ 89.3 536 1

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

6. 5.790 67.823 ↑ 1.0 1 1

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

  • Workers Planned: 2
  • Workers Launched: 2
7. 62.033 62.033 ↓ 0.0 0 3

Parallel Seq Scan on actor c (cost=0.00..23,592.46 rows=1 width=4) (actual time=47.126..62.033 rows=0 loops=3)

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

Index Scan using castspid on casts b (cost=0.43..12.59 rows=180 width=8) (actual time=0.020..0.126 rows=536 loops=1)

  • Index Cond: (pid = c.id)