#	exclusive	inclusive	rows x	rows	loops	node
1.	269.291	431.692	↑ 1.0	9714	1	→ Sort (cost=5379.62..5404.10 rows=9793 width=758) (actual time=386.695..431.692 rows=9714 loops=1) Sort Key: packages.pkgname Sort Method: external merge Disk: 7400kB
2.	51.543	162.401	↑ 1.0	9714	1	→ Hash Join (cost=2.23..1447.46 rows=9793 width=758) (actual time=0.273..162.401 rows=9714 loops=1) Hash Cond: (packages.arch_id = arches.id)
3.	54.544	110.804	↑ 1.0	9714	1	→ Hash Join (cost=1.16..1311.74 rows=9793 width=748) (actual time=0.149..110.804 rows=9714 loops=1) Hash Cond: (packages.repo_id = repos.id)
4.	56.209	56.209	↑ 1.0	9714	1	→ Seq Scan on packages (cost=0.00..1175.93 rows=9793 width=719) (actual time=0.036..56.209 rows=9714 loops=1)
5.	0.030	0.051	↑ 1.0	7	1	→ Hash (cost=1.07..1.07 rows=7 width=29) (actual time=0.051..0.051 rows=7 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
6.	0.021	0.021	↑ 1.0	7	1	→ Seq Scan on repos (cost=0.00..1.07 rows=7 width=29) (actual time=0.006..0.021 rows=7 loops=1)
7.	0.038	0.054	↑ 1.0	3	1	→ Hash (cost=1.03..1.03 rows=3 width=10) (actual time=0.054..0.054 rows=3 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 1kB
8.	0.016	0.016	↑ 1.0	3	1	→ Seq Scan on arches (cost=0.00..1.03 rows=3 width=10) (actual time=0.007..0.016 rows=3 loops=1)

                                                           QUERY PLAN                                                           
--------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=5379.62..5404.10 rows=9793 width=758) (actual time=386.695..431.692 rows=9714 loops=1)
   Sort Key: packages.pkgname
   Sort Method: external merge  Disk: 7400kB
   ->  Hash Join  (cost=2.23..1447.46 rows=9793 width=758) (actual time=0.273..162.401 rows=9714 loops=1)
         Hash Cond: (packages.arch_id = arches.id)
         ->  Hash Join  (cost=1.16..1311.74 rows=9793 width=748) (actual time=0.149..110.804 rows=9714 loops=1)
               Hash Cond: (packages.repo_id = repos.id)
               ->  Seq Scan on packages  (cost=0.00..1175.93 rows=9793 width=719) (actual time=0.036..56.209 rows=9714 loops=1)
               ->  Hash  (cost=1.07..1.07 rows=7 width=29) (actual time=0.051..0.051 rows=7 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 1kB
                     ->  Seq Scan on repos  (cost=0.00..1.07 rows=7 width=29) (actual time=0.006..0.021 rows=7 loops=1)
         ->  Hash  (cost=1.03..1.03 rows=3 width=10) (actual time=0.054..0.054 rows=3 loops=1)
               Buckets: 1024  Batches: 1  Memory Usage: 1kB
               ->  Seq Scan on arches  (cost=0.00..1.03 rows=3 width=10) (actual time=0.007..0.016 rows=3 loops=1)
 Total runtime: 461.684 ms

Per node type stats

node type	count	sum of times	% of query
Hash	2	0.068 ms	0.0 %
Hash Join	2	106.087 ms	24.6 %
Seq Scan	3	56.246 ms	13.0 %
Sort	1	269.291 ms	62.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
arches	1	0.016 ms	0.0 %
Seq Scan	1	0.016 ms	100.0 %
packages	1	56.209 ms	13.0 %
Seq Scan	1	56.209 ms	100.0 %
repos	1	0.021 ms	0.0 %
Seq Scan	1	0.021 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 7QZ

Colorize:

Columns visibility:

Per node type stats

Per table stats