1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on public.products (cost=0.00..4131733.02 rows=10000 width=32) (actual time=71.607..619.401 rows=10000 loops=1)
Output: products.id, products.name, (SubPlan 1), (SubPlan 2)
Buffers: shared hit=1142915
SubPlan 1
-> Aggregate (cost=41.42..41.43 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=10000)
Output: count(reviews.id)
Buffers: shared hit=119508
-> Bitmap Heap Scan on public.reviews (cost=4.37..41.39 rows=10 width=4) (actual time=0.002..0.005 rows=10 loops=10000)
Output: reviews.id, reviews.review_date, reviews.comment, reviews.product_id
Recheck Cond: (reviews.product_id = products.id)
Heap Blocks: exact=99508
Buffers: shared hit=119508
-> Bitmap Index Scan on reviews_product_id_idx (cost=0.00..4.37 rows=10 width=0) (actual time=0.001..0.001 rows=10 loops=10000)
Index Cond: (reviews.product_id = products.id)
Buffers: shared hit=20000
SubPlan 2
-> Aggregate (cost=371.71..371.72 rows=1 width=8) (actual time=0.048..0.048 rows=1 loops=10000)
Output: count(orders.id)
Buffers: shared hit=1023293
-> Bitmap Heap Scan on public.orders (cost=5.20..371.46 rows=100 width=4) (actual time=0.008..0.044 rows=100 loops=10000)
Output: orders.id, orders.order_date, orders.customer_name, orders.product_id
Recheck Cond: (orders.product_id = products.id)
Heap Blocks: exact=993293
Buffers: shared hit=1023293
-> Bitmap Index Scan on orders_product_id_idx (cost=0.00..5.17 rows=100 width=0) (actual time=0.002..0.002 rows=100 loops=10000)
Index Cond: (orders.product_id = products.id)
Buffers: shared hit=30000
Planning:
Buffers: shared hit=137
Planning Time: 0.307 ms
JIT:
Functions: 18
Options: Inlining true, Optimization true, Expressions true, Deforming true
Timing: Generation 0.404 ms, Inlining 36.770 ms, Optimization 20.753 ms, Emission 13.916 ms, Total 71.843 ms
Execution Time: 632.764 ms
(35 rows)
|
