explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4C9B

Settings
# exclusive inclusive rows x rows loops node
1. 237.156 18,784.864 ↓ 1.6 5,935 1

Hash Join (cost=168,523.94..210,804.85 rows=3,811 width=17) (actual time=15,828.748..18,784.864 rows=5,935 loops=1)

  • Hash Cond: (c.id = b.pid)
2. 2,794.542 2,794.542 ↑ 1.0 1,865,034 1

Seq Scan on actor c (cost=0.00..30,586.34 rows=1,865,034 width=4) (actual time=12.229..2,794.542 rows=1,865,034 loops=1)

3. 4.109 15,753.166 ↓ 1.6 5,935 1

Hash (cost=168,476.30..168,476.30 rows=3,811 width=21) (actual time=15,753.166..15,753.166 rows=5,935 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 380kB
4. 144.445 15,749.057 ↓ 1.6 5,935 1

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

  • Workers Planned: 2
  • Workers Launched: 2
5. 471.103 15,604.612 ↓ 1.2 1,978 3

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

  • Hash Cond: (b.mid = a.id)
6. 14,198.168 14,198.168 ↑ 1.2 3,815,282 3

Parallel Seq Scan on casts b (cost=0.00..119,470.39 rows=4,768,239 width=8) (actual time=5.630..14,198.168 rows=3,815,282 loops=3)

7. 2.707 935.341 ↓ 8.2 4,201 3

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

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

Seq Scan on movie a (cost=0.00..29,721.64 rows=512 width=21) (actual time=4.948..932.634 rows=4,201 loops=3)

  • Filter: (year > 2010)
  • Rows Removed by Filter: 1533210