explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KSZJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 778.211 ↑ 1.0 1 1

Unique (cost=181,993.68..181,993.69 rows=1 width=17) (actual time=778.211..778.211 rows=1 loops=1)

2. 0.008 778.210 ↑ 1.0 1 1

Sort (cost=181,993.68..181,993.69 rows=1 width=17) (actual time=778.210..778.210 rows=1 loops=1)

  • Sort Key: m.name
  • Sort Method: quicksort Memory: 25kB
3. 113.612 778.202 ↑ 1.0 1 1

Nested Loop (cost=25,592.48..181,993.67 rows=1 width=17) (actual time=691.483..778.202 rows=1 loops=1)

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

Gather (cost=1,000.00..19,797.15 rows=2,858 width=21) (actual time=0.358..0.832 rows=4,201 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 42.666 42.666 ↓ 1.2 1,400 3

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

  • Filter: (year > 2010)
  • Rows Removed by Filter: 511070
6. 74.938 663.758 ↓ 89.3 536 4,201

Materialize (cost=24,592.48..161,939.32 rows=6 width=4) (actual time=0.046..0.158 rows=536 loops=4,201)

7. 4.503 588.820 ↓ 89.3 536 1

Gather (cost=24,592.48..161,939.29 rows=6 width=4) (actual time=194.350..588.820 rows=536 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 258.859 584.317 ↓ 89.5 179 3

Parallel Hash Join (cost=23,592.48..160,938.69 rows=2 width=4) (actual time=190.024..584.317 rows=179 loops=3)

  • Hash Cond: (c.pid = a.id)
9. 261.862 261.862 ↑ 1.2 3,815,282 3

Parallel Seq Scan on casts c (cost=0.00..119,466.68 rows=4,767,868 width=8) (actual time=0.030..261.862 rows=3,815,282 loops=3)

10. 0.040 63.596 ↓ 0.0 0 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
11. 63.556 63.556 ↓ 0.0 0 3

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

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
Planning time : 0.312 ms
Execution time : 778.414 ms