Page MenuHomeSoftware Heritage
Paste P258

swh-dedup performance stats query planner
ActivePublic

Authored by seirl on May 24 2018, 9:13 PM.
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)