explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wMOw

Settings
# exclusive inclusive rows x rows loops node
1. 491.942 1,502.525 ↓ 5.0 5 1

Nested Loop (cost=41,911.52..200,191.51 rows=1 width=17) (actual time=912.716..1,502.525 rows=5 loops=1)

  • Join Filter: (c.mid = m.id)
  • Rows Removed by Join Filter: 9496307
2. 0.000 18.431 ↓ 1.4 17,717 1

Gather (cost=1,000.00..20,777.05 rows=12,657 width=21) (actual time=0.300..18.431 rows=17,717 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 46.120 46.120 ↓ 1.1 5,906 3

Parallel Seq Scan on movie m (cost=0.00..18,511.35 rows=5,274 width=21) (actual time=0.036..46.120 rows=5,906 loops=3)

  • Filter: (year >= 2010)
  • Rows Removed by Filter: 506565
4. 306.205 992.152 ↓ 89.3 536 17,717

Materialize (cost=40,911.52..178,275.35 rows=6 width=4) (actual time=0.017..0.056 rows=536 loops=17,717)

5. 4.696 685.947 ↓ 89.3 536 1

Gather (cost=40,911.52..178,275.32 rows=6 width=4) (actual time=299.988..685.947 rows=536 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 252.334 681.251 ↓ 89.5 179 3

Hash Join (cost=39,911.52..177,274.72 rows=2 width=4) (actual time=295.389..681.251 rows=179 loops=3)

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

Parallel Seq Scan on casts c (cost=0.00..119,479.03 rows=4,769,103 width=8) (actual time=0.022..256.104 rows=3,815,282 loops=3)

8. 0.007 172.813 ↑ 1.0 1 3

Hash (cost=39,911.51..39,911.51 rows=1 width=4) (actual time=172.813..172.813 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 172.806 172.806 ↑ 1.0 1 3

Seq Scan on actor a (cost=0.00..39,911.51 rows=1 width=4) (actual time=39.936..172.806 rows=1 loops=3)

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 1865033