Page Menu
Home
Software Heritage
Search
Configure Global Search
Log In
Paste
P258
swh-dedup performance stats query planner
Active
Public
Actions
Authored by
seirl
on May 24 2018, 9:13 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Subscribers
None
swh
-
dedup
=#
explain
select
count
(
distinct
chunk
.
id
)
as
count_chunk
,
sum
(
chunk
.
length
)
as
total_size
,
sum
(
chunk
.
compressed_length
)
as
total_compressed_size
from
chunked_content
left
join
chunked_content_chunk
on
chunked_content_id
=
chunked_content
.
id
left
join
chunk
on
chunk
.
id
=
chunked_content_chunk
.
chunk_id
where
method_id
=
1
;
QUERY
PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate
(
cost
=
122093664.99..122093665.00
rows
=
1
width
=
24
)
->
Hash
Left
Join
(
cost
=
50837550.73..121154640.35
rows
=
125203285
width
=
29
)
Hash
Cond
:
((
chunked_content_chunk
.
chunk_id
)
::
bytea
=
(
chunk
.
id
)
::
bytea
)
->
Hash
Right
Join
(
cost
=
673121.09..58595737.23
rows
=
125203285
width
=
21
)
Hash
Cond
:
(
chunked_content_chunk
.
chunked_content_id
=
chunked_content
.
id
)
->
Seq
Scan
on
chunked_content_chunk
(
cost
=
0.00..33529227.32
rows
=
1932149632
width
=
25
)
->
Hash
(
cost
=
623208.67..623208.67
rows
=
3992993
width
=
4
)
->
Bitmap
Heap
Scan
on
chunked_content
(
cost
=
58786.26..623208.67
rows
=
3992993
width
=
4
)
Recheck
Cond
:
(
method_id
=
1
)
->
Bitmap
Index
Scan
on
chunked_content_method_id_idx
(
cost
=
0.00..57788.01
rows
=
3992993
width
=
0
)
Index
Cond
:
(
method_id
=
1
)
->
Hash
(
cost
=
23727028.84..23727028.84
rows
=
1367267584
width
=
29
)
->
Seq
Scan
on
chunk
(
cost
=
0.00..23727028.84
rows
=
1367267584
width
=
29
)
(
13
rows
)
Event Timeline
seirl
created this paste.
May 24 2018, 9:13 PM
2018-05-24 21:13:06 (UTC+2)
Log In to Comment