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..280600.32 rows=10000 width=32) (actual time=5.206..2498.463 rows=10000 loops=1)
Output: products.id, products.name, count(DISTINCT reviews.id), count(DISTINCT orders.id)
Group Key: products.id
Buffers: shared hit=1093923
-> Merge Left Join (cost=1.00..205500.32 rows=10000000 width=24) (actual time=4.720..1482.634 rows=9995979 loops=1)
Output: products.id, products.name, reviews.id, orders.id
Merge Cond: (products.id = orders.product_id)
Buffers: shared hit=1093923
-> Merge Left Join (cost=0.58..7362.19 rows=100000 width=20) (actual time=4.706..51.596 rows=100000 loops=1)
Output: products.id, products.name, reviews.id
Merge Cond: (products.id = reviews.product_id)
Buffers: shared hit=99765
-> Index Scan using products_pkey on public.products (cost=0.29..387.29 rows=10000 width=16) (actual time=0.010..1.926 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..5699.91 rows=100000 width=8) (actual time=0.008..34.368 rows=100000 loops=1)
Output: reviews.id, reviews.review_date, reviews.comment, reviews.product_id
Buffers: shared hit=99622
-> Materialize (cost=0.42..50388.13 rows=1000000 width=8) (actual time=0.010..626.788 rows=9995969 loops=1)
Output: orders.id, orders.order_date, orders.customer_name, orders.product_id
Buffers: shared hit=994158
-> Index Scan using orders_product_id_idx on public.orders (cost=0.42..47888.13 rows=1000000 width=8) (actual time=0.009..324.399 rows=1000000 loops=1)
Output: orders.id, orders.order_date, orders.customer_name, orders.product_id
Buffers: shared hit=994158
Planning:
Buffers: shared hit=181
Planning Time: 0.467 ms
JIT:
Functions: 15
Options: Inlining false, Optimization false, Expressions true, Deforming true
Timing: Generation 0.365 ms, Inlining 0.000 ms, Optimization 0.194 ms, Emission 4.497 ms, Total 5.055 ms
Execution Time: 2511.587 ms
(32 rows)
|
