explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DSH6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 788.931 ↑ 1.0 1 1

Nested Loop (cost=31,728.04..193,116.50 rows=1 width=17) (actual time=346.838..788.931 rows=1 loops=1)

  • Join Filter: (c.pid = a.id)
  • Rows Removed by Join Filter: 5934
2. 2.513 61.538 ↑ 1.0 1 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 59.025 59.025 ↓ 0.0 0 3

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

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
4. 3.645 728.065 ↓ 1.6 5,935 1

Gather (cost=30,728.04..168,476.30 rows=3,811 width=21) (actual time=139.038..728.065 rows=5,935 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 312.775 724.420 ↓ 1.2 1,978 3

Hash Join (cost=29,728.04..167,095.20 rows=1,588 width=21) (actual time=138.315..724.420 rows=1,978 loops=3)

  • Hash Cond: (c.mid = m.id)
6. 273.572 273.572 ↑ 1.2 3,815,282 3

Parallel Seq Scan on casts c (cost=0.00..119,470.39 rows=4,768,239 width=8) (actual time=0.020..273.572 rows=3,815,282 loops=3)

7. 1.278 138.073 ↓ 8.2 4,201 3

Hash (cost=29,721.64..29,721.64 rows=512 width=21) (actual time=138.073..138.073 rows=4,201 loops=3)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 288kB
8. 136.795 136.795 ↓ 8.2 4,201 3

Seq Scan on movie m (cost=0.00..29,721.64 rows=512 width=21) (actual time=0.018..136.795 rows=4,201 loops=3)

  • Filter: (year > 2010)
  • Rows Removed by Filter: 1533210
Planning time : 0.317 ms
Execution time : 790.100 ms