explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MP7N

Settings
# exclusive inclusive rows x rows loops node
1. 2,332.451 13,113.982 ↑ 1.0 1 1

Nested Loop (cost=25,592.48..182,225.49 rows=1 width=17) (actual time=11,003.475..13,113.982 rows=1 loops=1)

  • Join Filter: (c.mid = m.id)
  • Rows Removed by Join Filter: 2251735
2. 0.000 5.966 ↓ 1.1 4,201 1

Gather (cost=1,000.00..19,909.75 rows=3,984 width=21) (actual time=0.298..5.966 rows=4,201 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 75.883 75.883 ↑ 1.2 1,400 3

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

  • Filter: (year > 2010)
  • Rows Removed by Filter: 511070
4. 2,250.191 10,775.565 ↓ 89.3 536 4,201

Materialize (cost=24,592.48..161,957.19 rows=6 width=4) (actual time=0.524..2.565 rows=536 loops=4,201)

5. 3.536 8,525.374 ↓ 89.3 536 1

Gather (cost=24,592.48..161,957.16 rows=6 width=4) (actual time=2,195.320..8,525.374 rows=536 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 4,209.154 8,521.838 ↓ 89.5 179 3

Parallel Hash Join (cost=23,592.48..160,956.56 rows=2 width=4) (actual time=2,191.556..8,521.838 rows=179 loops=3)

  • Hash Cond: (c.pid = a.id)
7. 4,216.719 4,216.719 ↑ 1.3 3,815,282 3

Parallel Seq Scan on casts c (cost=0.00..119,479.68 rows=4,769,168 width=8) (actual time=0.040..4,216.719 rows=3,815,282 loops=3)

8. 0.056 95.965 ↓ 0.0 0 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
9. 95.909 95.909 ↓ 0.0 0 3

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

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
Planning time : 0.254 ms
Execution time : 13,114.397 ms