explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pnlp

Settings
# exclusive inclusive rows x rows loops node
1. 17.905 9,046.850 ↑ 1.0 1 1

Gather (cost=161,956.59..180,474.89 rows=1 width=17) (actual time=9,043.317..9,046.850 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2.167 9,028.945 ↓ 0.0 0 3

Parallel Hash Join (cost=160,956.59..179,474.79 rows=1 width=17) (actual time=9,014.651..9,028.945 rows=0 loops=3)

  • Hash Cond: (m.id = c.mid)
3. 67.249 67.249 ↑ 1.3 1,400 3

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

  • Filter: (year > 2010)
  • Rows Removed by Filter: 511070
4. 0.434 8,959.529 ↓ 89.5 179 3

Parallel Hash (cost=160,956.56..160,956.56 rows=2 width=4) (actual time=8,959.528..8,959.529 rows=179 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
5. 4,316.082 8,959.095 ↓ 89.5 179 3

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

  • Hash Cond: (c.pid = a.id)
6. 4,534.646 4,534.646 ↑ 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.044..4,534.646 rows=3,815,282 loops=3)

7. 0.060 108.367 ↓ 0.0 0 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
8. 108.307 108.307 ↓ 0.0 0 3

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

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
Planning time : 0.398 ms
Execution time : 9,046.964 ms