#	exclusive	inclusive	rows x	rows	loops	node
1.	11739.433	12494.520	↑ 1.0	1000000	1	→ Sort (cost=332686.74..335186.74 rows=1000000 width=99) (actual time=12272.760..12494.520 rows=1000000 loops=1) Sort Key: tmp_ap_di.fs_party Sort Method: external sort Disk: 106552kB
2.	520.659	755.087	↑ 1.0	1000000	1	→ Hash Join (cost=2473.40..68966.40 rows=1000000 width=99) (actual time=32.973..755.087 rows=1000000 loops=1) Hash Cond: ((tmp_cm_ledgeritem.salesteam)::text = (tmp_ap_di.ap_tril_gid)::text)
3.	201.491	201.491	↑ 1.0	1000000	1	→ Seq Scan on tmp_cm_ledgeritem (cost=0.00..22346.00 rows=1000000 width=66) (actual time=0.014..201.491 rows=1000000 loops=1)
4.	23.237	32.937	↑ 1.0	45351	1	→ Hash (cost=1197.51..1197.51 rows=45351 width=99) (actual time=32.937..32.937 rows=45351 loops=1)
5.	9.700	9.700	↑ 1.0	45351	1	→ Seq Scan on tmp_ap_di (cost=0.00..1197.51 rows=45351 width=99) (actual time=0.008..9.700 rows=45351 loops=1)

"Sort  (cost=332686.74..335186.74 rows=1000000 width=99) (actual time=12272.760..12494.520 rows=1000000 loops=1)"
"  Sort Key: tmp_ap_di.fs_party"
"  Sort Method:  external sort  Disk: 106552kB"
"  ->  Hash Join  (cost=2473.40..68966.40 rows=1000000 width=99) (actual time=32.973..755.087 rows=1000000 loops=1)"
"        Hash Cond: ((tmp_cm_ledgeritem.salesteam)::text = (tmp_ap_di.ap_tril_gid)::text)"
"        ->  Seq Scan on tmp_cm_ledgeritem  (cost=0.00..22346.00 rows=1000000 width=66) (actual time=0.014..201.491 rows=1000000 loops=1)"
"        ->  Hash  (cost=1197.51..1197.51 rows=45351 width=99) (actual time=32.937..32.937 rows=45351 loops=1)"
"              ->  Seq Scan on tmp_ap_di  (cost=0.00..1197.51 rows=45351 width=99) (actual time=0.008..9.700 rows=45351 loops=1)"
"Total runtime: 12591.583 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	1	23.237 ms	0.2 %
Hash Join	1	520.659 ms	4.2 %
Seq Scan	2	211.191 ms	1.7 %
Sort	1	11739.433 ms	94.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
tmp_ap_di	1	9.700 ms	0.1 %
Seq Scan	1	9.700 ms	100.0 %
tmp_cm_ledgeritem	1	201.491 ms	1.6 %
Seq Scan	1	201.491 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: jxm

Colorize:

Columns visibility:

Per node type stats

Per table stats