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
|
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
GroupAggregate (cost=1.00..280612.99 rows=10000 width=32) (actual time=5.465..2682.441 rows=10000 loops=1)
Output: products.id, products.name, count(DISTINCT reviews.id), count(DISTINCT orders.id)
Group Key: products.id
Buffers: shared hit=1093885
-> Merge Left Join (cost=1.00..205512.99 rows=10000000 width=24) (actual time=4.829..1538.277 rows=9998159 loops=1)
Output: products.id, products.name, reviews.id, orders.id
Merge Cond: (products.id = orders.product_id)
Buffers: shared hit=1093885
-> Merge Left Join (cost=0.58..7362.56 rows=100000 width=20) (actual time=4.809..53.801 rows=100000 loops=1)
Output: products.id, products.name, reviews.id
Merge Cond: (products.id = reviews.product_id)
Buffers: shared hit=99720
-> Index Scan using products_pkey on public.products (cost=0.29..387.29 rows=10000 width=16) (actual time=0.013..1.850 rows=10000 loops=1)
Output: products.id, products.name, products.description, products.price, products.created_at
Buffers: shared hit=143
-> Index Scan using reviews_product_id_idx on public.reviews (cost=0.29..5700.28 rows=100000 width=8) (actual time=0.015..35.760 rows=100000 loops=1)
Output: reviews.id, reviews.review_date, reviews.comment, reviews.product_id
Buffers: shared hit=99577
-> Materialize (cost=0.42..50400.42 rows=1000000 width=8) (actual time=0.015..638.811 rows=9998150 loops=1)
Output: orders.id, orders.order_date, orders.customer_name, orders.product_id
Buffers: shared hit=994165
-> Index Scan using orders_product_id_idx on public.orders (cost=0.42..47900.42 rows=1000000 width=8) (actual time=0.013..325.213 rows=1000000 loops=1)
Output: orders.id, orders.order_date, orders.customer_name, orders.product_id
Buffers: shared hit=994165
Planning:
Buffers: shared hit=181
Planning Time: 0.448 ms
JIT:
Functions: 15
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.370 ms, Inlining 0.000 ms, Optimization 0.199 ms, Emission 4.585 ms, Total 5.154 ms
Execution Time: 2696.039 ms
(32 rows)
|
