gistfile1.txt

┌─────────────────────────────────────────────────────────────────────────────────────────────┐
│                                         QUERY PLAN                                          │
├─────────────────────────────────────────────────────────────────────────────────────────────┤
│ Index Scan using index_large_on_scope_id_and_busy_column on large  (cost=0.44…              │
│…..5877.24 rows=5516 width=4) (actual time=2.095..8.282 rows=5153 loops=1)                   │
│   Index Cond: ((scope_id = 501) AND (busy_column >= 3))                                     │
│ Planning Time: 0.454 ms                                                                     │
│ Execution Time: 8.482 ms                                                                    │
└─────────────────────────────────────────────────────────────────────────────────────────────┘
(4 rows)

┌─────────────────────────────────────────────────────────────────────────────────────────────┐
│                                         QUERY PLAN                                          │
├─────────────────────────────────────────────────────────────────────────────────────────────┤
│ Gather Merge  (cost=1000.88..65534.59 rows=5737 width=4) (actual time=6.818..74.543 rows=51…│
│…53 loops=1)                                                                                 │
│   Workers Planned: 1                                                                        │
│   Workers Launched: 1                                                                       │
│   ->  Nested Loop  (cost=0.88..63889.17 rows=3375 width=4) (actual time=0.110..49.443 rows=…│
│…2576 loops=2)                                                                               │
│         ->  Parallel Index Only Scan Backward using index_large_on_scope_id_and_id on l…    │
│…arge  (cost=0.44..37134.44 rows=20721 width=4) (actual time=0.041..20.790 rows=16686 loop…  │
│…s=2)                                                                                        │
│               Index Cond: (scope_id = 501)                                                  │
│               Heap Fetches: 33373                                                           │
│         ->  Index Only Scan using foo on large_caches pc  (cost=0.44..1.29 rows=1 width=4)… │
│… (actual time=0.002..0.002 rows=0 loops=33373)                                              │
│               Index Cond: ((large_id = large.id) AND (busy_column >= 3))                    │
│               Heap Fetches: 0                                                               │
│ Planning Time: 0.723 ms                                                                     │
│ Execution Time: 74.837 ms                                                                   │
└─────────────────────────────────────────────────────────────────────────────────────────────┘