Set to 1.0:
pulpcore=# show cursor_tuple_fraction;
cursor_tuple_fraction
-----------------------
1
(1 row)
no difference
pulpcore=# EXPLAIN analyze SELECT "core_content"."pulp_id" FROM "core_content" WHERE ("core_content"."pulp_id" IN ('496440d4-1388-4ba5-a1fc-16cbdc29da89'::uuid, 'f28544f0-b8f4-42b4-806b-b09b2f0eaa7a'::uuid, 'f5c40092-0c30-47f1-a213-acd7b25df32a'::uuid, 'a327d603-7c42-4243-96c8-6d0a0f422c78'::uuid) AND NOT ("core_content"."pulp_id" IN (SELECT V0."pulp_id" FROM "core_content" V0 WHERE V0."pulp_id" IN (SELECT U0."content_id" FROM "core_repositorycontent" U0 INNER JOIN "core_repositoryversion" U2 ON (U0."version_added_id" = U2."pulp_id") LEFT OUTER JOIN "core_repositoryversion" U3 ON (U0."version_removed_id" = U3."pulp_id") WHERE (U0."repository_id" = '43e7b651-8399-4bda-b54e-900dea17af7e'::uuid AND U2."number" <= 235 AND NOT (U3."number" <= 235 AND U3."number" IS NOT NULL))))));
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Index Only Scan using core_content_pkey on core_content (cost=48176.71..48202.06 rows=2 width=16) (actual time=4084078.606..4084078.615 rows=0 loops=1)
Index Cond: (pulp_id = ANY ('{496440d4-1388-4ba5-a1fc-16cbdc29da89,f28544f0-b8f4-42b4-806b-b09b2f0eaa7a,f5c40092-0c30-47f1-a213-acd7b25df32a,a327d603-7c42-4243-96c8-6d0a0f422c78}'::uuid[]))
Filter: (NOT (hashed SubPlan 1))
Rows Removed by Filter: 4
Heap Fetches: 4
SubPlan 1
-> Nested Loop Semi Join (cost=4009.00..48176.29 rows=1 width=16) (actual time=7261.857..4083991.655 rows=43595 loops=1)
Join Filter: (v0.pulp_id = u0.content_id)
Rows Removed by Join Filter: 11214159825
-> Seq Scan on core_content v0 (cost=0.00..7129.81 rows=278881 width=16) (actual time=0.008..218.406 rows=279033 loops=1)
-> Materialize (cost=4009.00..36863.27 rows=1 width=16) (actual time=0.000..7.100 rows=40190 loops=279033)
-> Nested Loop (cost=4009.00..36863.26 rows=1 width=16) (actual time=6.145..20216.874 rows=43595 loops=1)
Join Filter: (u0.version_added_id = u2.pulp_id)
Rows Removed by Join Filter: 48636032
-> Hash Left Join (cost=4009.00..36793.66 rows=1 width=32) (actual time=5.686..52.092 rows=43595 loops=1)
Hash Cond: (u0.version_removed_id = u3.pulp_id)
Filter: ((u3.number > 235) OR (u3.number IS NULL))
Rows Removed by Filter: 22
-> Bitmap Heap Scan on core_repositorycontent u0 (cost=3943.86..36617.66 rows=42233 width=48) (actual time=4.655..30.371 rows=43617 loops=1)
Recheck Cond: (repository_id = '43e7b651-8399-4bda-b54e-900dea17af7e'::uuid)
Heap Blocks: exact=3240
-> Bitmap Index Scan on core_repositorycontent_repository_id_1946e61b (cost=0.00..3933.30 rows=42233 width=0) (actual time=4.333..4.334 rows=43639 loops=1)
Index Cond: (repository_id = '43e7b651-8399-4bda-b54e-900dea17af7e'::uuid)
-> Hash (cost=42.84..42.84 rows=1784 width=20) (actual time=1.022..1.024 rows=1887 loops=1)
Buckets: 2048 Batches: 1 Memory Usage: 112kB
-> Seq Scan on core_repositoryversion u3 (cost=0.00..42.84 rows=1784 width=20) (actual time=0.010..0.554 rows=1887 loops=1)
-> Seq Scan on core_repositoryversion u2 (cost=0.00..47.30 rows=1784 width=16) (actual time=0.002..0.260 rows=1117 loops=43595)
Filter: (number <= 235)
Planning Time: 0.747 ms
Execution Time: 4084079.915 ms
(30 rows)