#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	3206.623	↑ 1.0	5	1	→ Limit (cost=233819.86..233819.87 rows=5 width=16) (actual time=3206.621..3206.623 rows=5 loops=1)
2.	502.012	3206.621	↑ 600000.4	5	1	→ Sort (cost=233819.86..241319.86 rows=3000002 width=16) (actual time=3206.619..3206.621 rows=5 loops=1) Sort Key: cg.created Sort Method: top-N heapsort Memory: 25kB
3.	1963.459	2704.609	↑ 1.0	3000002	1	→ Hash Join (cost=42270.85..183990.90 rows=3000002 width=16) (actual time=257.430..2704.609 rows=3000002 loops=1) Hash Cond: (cg.issueid = jiraissue.id)
4.	483.818	483.818	↑ 1.0	3000002	1	→ Seq Scan on changegroup cg (cost=0.00..55000.02 rows=3000002 width=16) (actual time=0.008..483.818 rows=3000002 loops=1)
5.	74.765	257.332	↑ 1.0	300000	1	→ Hash (cost=37348.85..37348.85 rows=300000 width=8) (actual time=257.332..257.332 rows=300000 loops=1)
6.	125.395	182.567	↑ 1.0	300000	1	→ Hash Semi Join (cost=21.85..37348.85 rows=300000 width=8) (actual time=0.219..182.567 rows=300000 loops=1) Hash Cond: (jiraissue.project = project.id)
7.	56.962	56.962	↑ 1.0	300000	1	→ Seq Scan on jiraissue (cost=0.00..33202.00 rows=300000 width=17) (actual time=0.003..56.962 rows=300000 loops=1)
8.	0.122	0.210	↑ 1.0	571	1	→ Hash (cost=14.71..14.71 rows=571 width=9) (actual time=0.210..0.210 rows=571 loops=1)
9.	0.088	0.088	↑ 1.0	571	1	→ Seq Scan on project (cost=0.00..14.71 rows=571 width=9) (actual time=0.004..0.088 rows=571 loops=1)

"Limit  (cost=233819.86..233819.87 rows=5 width=16) (actual time=3206.621..3206.623 rows=5 loops=1)"
"  ->  Sort  (cost=233819.86..241319.86 rows=3000002 width=16) (actual time=3206.619..3206.621 rows=5 loops=1)"
"        Sort Key: cg.created"
"        Sort Method:  top-N heapsort  Memory: 25kB"
"        ->  Hash Join  (cost=42270.85..183990.90 rows=3000002 width=16) (actual time=257.430..2704.609 rows=3000002 loops=1)"
"              Hash Cond: (cg.issueid = jiraissue.id)"
"              ->  Seq Scan on changegroup cg  (cost=0.00..55000.02 rows=3000002 width=16) (actual time=0.008..483.818 rows=3000002 loops=1)"
"              ->  Hash  (cost=37348.85..37348.85 rows=300000 width=8) (actual time=257.332..257.332 rows=300000 loops=1)"
"                    ->  Hash Semi Join  (cost=21.85..37348.85 rows=300000 width=8) (actual time=0.219..182.567 rows=300000 loops=1)"
"                          Hash Cond: (jiraissue.project = project.id)"
"                          ->  Seq Scan on jiraissue  (cost=0.00..33202.00 rows=300000 width=17) (actual time=0.003..56.962 rows=300000 loops=1)"
"                          ->  Hash  (cost=14.71..14.71 rows=571 width=9) (actual time=0.210..0.210 rows=571 loops=1)"
"                                ->  Seq Scan on project  (cost=0.00..14.71 rows=571 width=9) (actual time=0.004..0.088 rows=571 loops=1)"
"Total runtime: 3206.685 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	2	74.887 ms	2.3 %
Hash Join	1	1963.459 ms	61.2 %
Hash Semi Join	1	125.395 ms	3.9 %
Limit	1	0.002 ms	0.0 %
Seq Scan	3	540.868 ms	16.9 %
Sort	1	502.012 ms	15.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
changegroup	1	483.818 ms	15.1 %
Seq Scan	1	483.818 ms	100.0 %
jiraissue	1	56.962 ms	1.8 %
Seq Scan	1	56.962 ms	100.0 %
project	1	0.088 ms	0.0 %
Seq Scan	1	0.088 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: XTf

Colorize:

Columns visibility:

Per node type stats

Per table stats