Pager usage is off. SET QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Finalize Aggregate (cost=280264.91..280264.92 rows=1 width=64) (actual time=2741.164..2763.554 rows=1.00 loops=1) Buffers: shared hit=4178268 read=1093110, temp read=22572 written=22652 -> Gather (cost=280264.69..280264.90 rows=2 width=64) (actual time=2738.152..2763.550 rows=3.00 loops=1) Workers Planned: 2 Workers Launched: 2 Buffers: shared hit=4178268 read=1093110, temp read=22572 written=22652 -> Partial Aggregate (cost=279264.69..279264.70 rows=1 width=64) (actual time=2736.217..2736.250 rows=1.00 loops=3) Buffers: shared hit=4178268 read=1093110, temp read=22572 written=22652 -> Parallel Hash Join (cost=136368.90..271857.81 rows=1481375 width=33) (actual time=2244.259..2397.555 rows=1236864.00 loops=3) Hash Cond: (n.id = an.person_id) Buffers: shared hit=4178268 read=1093110, temp read=22572 written=22652 -> Nested Loop (cost=114301.82..235944.12 rows=635491 width=25) (actual time=198.873..2044.905 rows=944185.00 loops=3) Buffers: shared hit=4177986 read=1081976, temp read=1698 written=1704 -> Nested Loop (cost=114301.38..188137.25 rows=635491 width=21) (actual time=198.784..1236.382 rows=944185.00 loops=3) Join Filter: (ci.movie_id = t.id) Buffers: shared hit=2546486 read=732334, temp read=1698 written=1704 -> Nested Loop (cost=114300.94..131790.25 rows=30693 width=29) (actual time=198.716..273.204 rows=22772.00 loops=3) Buffers: shared hit=268202 read=61791, temp read=1698 written=1704 -> Merge Join (cost=114300.51..116833.42 rows=30693 width=8) (actual time=198.599..222.967 rows=22772.00 loops=3) Merge Cond: (mc.movie_id = mk.movie_id) Buffers: shared hit=23792 read=32935, temp read=1698 written=1704 -> Sort (cost=81821.71..82837.92 rows=406485 width=4) (actual time=126.514..138.221 rows=384599.00 loops=3) Sort Key: mc.movie_id Sort Method: external merge Disk: 4584kB Buffers: shared hit=8 read=21864, temp read=1698 written=1704 Worker 0: Sort Method: external merge Disk: 4536kB Worker 1: Sort Method: external merge Disk: 4464kB -> Parallel Hash Join (cost=5393.42..38393.85 rows=406485 width=4) (actual time=10.192..94.773 rows=384599.00 loops=3) Hash Cond: (mc.company_id = cn.id) Buffers: shared read=21864 -> Parallel Seq Scan on movie_companies mc (cost=0.00..30052.81 rows=1122881 width=8) (actual time=0.108..28.237 rows=869709.33 loops=3) Buffers: shared read=18824 -> Parallel Hash (cost=4767.91..4767.91 rows=50041 width=4) (actual time=10.007..10.007 rows=28281.00 loops=3) Buckets: 131072 Batches: 1 Memory Usage: 4416kB Buffers: shared read=3040 -> Parallel Seq Scan on company_name cn (cost=0.00..4767.91 rows=50041 width=4) (actual time=0.104..8.026 rows=28281.00 loops=3) Filter: ((country_code)::text = '[us]'::text) Rows Removed by Filter: 50051 Buffers: shared read=3040 -> Sort (cost=32478.65..32575.53 rows=38749 width=4) (actual time=72.067..73.364 rows=52744.00 loops=3) Sort Key: mk.movie_id Sort Method: quicksort Memory: 1537kB Buffers: shared hit=23784 read=11071 Worker 0: Sort Method: quicksort Memory: 1537kB Worker 1: Sort Method: quicksort Memory: 1537kB -> Nested Loop (cost=444.74..29525.62 rows=38749 width=4) (actual time=2.513..69.487 rows=41840.00 loops=3) Buffers: shared hit=23784 read=11071 -> Seq Scan on keyword k (cost=0.00..2685.11 rows=1 width=4) (actual time=0.302..3.581 rows=1.00 loops=3) Filter: (keyword = 'character-name-in-title'::text) Rows Removed by Filter: 134168 Buffers: shared hit=2987 read=37 -> Bitmap Heap Scan on movie_keyword mk (cost=444.74..26453.01 rows=38749 width=8) (actual time=2.209..63.804 rows=41840.00 loops=3) Recheck Cond: (k.id = keyword_id) Heap Blocks: exact=11547 Buffers: shared hit=20797 read=11034 -> Bitmap Index Scan on keyword_id_movie_keyword (cost=0.00..435.05 rows=38749 width=0) (actual time=1.266..1.266 rows=41840.00 loops=3) Index Cond: (keyword_id = k.id) Index Searches: 3 Buffers: shared hit=80 read=36 -> Index Scan using title_pkey on title t (cost=0.43..0.49 rows=1 width=21) (actual time=0.002..0.002 rows=1.00 loops=68316) Index Cond: (id = mk.movie_id) Index Searches: 68316 Buffers: shared hit=244410 read=28856 -> Index Scan using movie_id_cast_info on cast_info ci (cost=0.44..1.36 rows=38 width=8) (actual time=0.003..0.040 rows=41.46 loops=68316) Index Cond: (movie_id = mk.movie_id) Index Searches: 68316 Buffers: shared hit=2278284 read=670543 -> Memoize (cost=0.44..0.46 rows=1 width=4) (actual time=0.001..0.001 rows=1.00 loops=2832555) Cache Key: ci.person_id Cache Mode: logical Estimates: capacity=71064 distinct keys=71064 lookups=635491 hit percent=88.82% Hits: 724363 Misses: 200258 Evictions: 119594 Overflows: 0 Memory Usage: 8193kB Buffers: shared hit=1631500 read=349642 Worker 0: Hits: 744868 Misses: 209441 Evictions: 128778 Overflows: 0 Memory Usage: 8193kB Worker 1: Hits: 745857 Misses: 207768 Evictions: 127108 Overflows: 0 Memory Usage: 8193kB -> Index Only Scan using name_pkey on name n (cost=0.43..0.45 rows=1 width=4) (actual time=0.003..0.003 rows=1.00 loops=617467) Index Cond: (id = ci.person_id) Heap Fetches: 0 Index Searches: 617467 Buffers: shared hit=1631500 read=349642 -> Parallel Hash (cost=15171.59..15171.59 rows=375559 width=20) (actual time=48.749..48.750 rows=300447.33 loops=3) Buckets: 131072 Batches: 8 Memory Usage: 7296kB Buffers: shared hit=282 read=11134, temp written=4116 -> Parallel Seq Scan on aka_name an (cost=0.00..15171.59 rows=375559 width=20) (actual time=0.095..18.852 rows=300447.33 loops=3) Buffers: shared hit=282 read=11134 Planning: Buffers: shared hit=837 read=144 Planning Time: 5.321 ms Execution Time: 2764.320 ms (89 rows)