#	exclusive	inclusive	rows x	rows	loops	node
1.	503.261	1861.708	↓ 1.0	1000000	1	→ Hash Join (cost=94073.96..341084.23 rows=980110 width=566) (actual time=529.319..1861.708 rows=1000000 loops=1) Hash Cond: ((cm_ledgeritem.salesteam)::text = (fs_agrperson.tril_gid)::text)
2.	829.160	829.160	↓ 1.0	1000000	1	→ Seq Scan on cm_ledgeritem (cost=0.00..99075.12 rows=998405 width=500) (actual time=0.010..829.160 rows=1000000 loops=1) Filter: (fs_batchid = 1)
3.	23.748	529.287	↓ 1.0	45351	1	→ Hash (cost=92821.46..92821.46 rows=44520 width=99) (actual time=529.287..529.287 rows=45351 loops=1)
4.	54.790	505.539	↓ 1.0	45351	1	→ Hash Join (cost=2886.40..92821.46 rows=44520 width=99) (actual time=121.001..505.539 rows=45351 loops=1) Hash Cond: ((fs_debtitem.fs_party)::text = (fs_agrperson.fs_party)::text)
5.	396.277	396.277	↓ 1.0	45351	1	→ Seq Scan on fs_debtitem (cost=0.00..87468.66 rows=44520 width=66) (actual time=66.387..396.277 rows=45351 loops=1) Filter: (fs_annualize = 0)
6.	19.645	54.472	↑ 1.0	45351	1	→ Hash (cost=1787.51..1787.51 rows=45351 width=66) (actual time=54.472..54.472 rows=45351 loops=1)
7.	34.827	34.827	↑ 1.0	45351	1	→ Seq Scan on fs_agrperson (cost=0.00..1787.51 rows=45351 width=66) (actual time=0.017..34.827 rows=45351 loops=1)

"Hash Join  (cost=94073.96..341084.23 rows=980110 width=566) (actual time=529.319..1861.708 rows=1000000 loops=1)"
"  Hash Cond: ((cm_ledgeritem.salesteam)::text = (fs_agrperson.tril_gid)::text)"
"  ->  Seq Scan on cm_ledgeritem  (cost=0.00..99075.12 rows=998405 width=500) (actual time=0.010..829.160 rows=1000000 loops=1)"
"        Filter: (fs_batchid = 1)"
"  ->  Hash  (cost=92821.46..92821.46 rows=44520 width=99) (actual time=529.287..529.287 rows=45351 loops=1)"
"        ->  Hash Join  (cost=2886.40..92821.46 rows=44520 width=99) (actual time=121.001..505.539 rows=45351 loops=1)"
"              Hash Cond: ((fs_debtitem.fs_party)::text = (fs_agrperson.fs_party)::text)"
"              ->  Seq Scan on fs_debtitem  (cost=0.00..87468.66 rows=44520 width=66) (actual time=66.387..396.277 rows=45351 loops=1)"
"                    Filter: (fs_annualize = 0)"
"              ->  Hash  (cost=1787.51..1787.51 rows=45351 width=66) (actual time=54.472..54.472 rows=45351 loops=1)"
"                    ->  Seq Scan on fs_agrperson  (cost=0.00..1787.51 rows=45351 width=66) (actual time=0.017..34.827 rows=45351 loops=1)"
"Total runtime: 1914.264 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	2	43.393 ms	2.3 %
Hash Join	2	558.051 ms	30.0 %
Seq Scan	3	1260.264 ms	67.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cm_ledgeritem	1	829.160 ms	44.5 %
Seq Scan	1	829.160 ms	100.0 %
fs_agrperson	1	34.827 ms	1.9 %
Seq Scan	1	34.827 ms	100.0 %
fs_debtitem	1	396.277 ms	21.3 %
Seq Scan	1	396.277 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ZvM

Colorize:

Columns visibility:

Per node type stats

Per table stats