#	exclusive	inclusive	rows x	rows	loops	node
1.	4244.435	19802.139	↓ 1.0	1000000	1	→ Merge Join (cost=1398900.98..1419034.34 rows=980110 width=599) (actual time=15145.778..19802.139 rows=1000000 loops=1) Merge Cond: ((fs_agrperson.fs_party)::text = (fs_debtitem.fs_party)::text)
2.	12625.424	14234.234	↓ 1.0	1000000	1	→ Sort (cost=1306165.01..1308661.03 rows=998405 width=533) (actual time=13864.657..14234.234 rows=1000000 loops=1) Sort Key: fs_agrperson.fs_party Sort Method: external sort Disk: 306952kB
3.	587.471	1608.810	↓ 1.0	1000000	1	→ Hash Join (cost=2886.40..251163.62 rows=998405 width=533) (actual time=64.913..1608.810 rows=1000000 loops=1) Hash Cond: ((cm_ledgeritem.salesteam)::text = (fs_agrperson.tril_gid)::text)
4.	956.457	956.457	↓ 1.0	1000000	1	→ Seq Scan on cm_ledgeritem (cost=0.00..99075.12 rows=998405 width=500) (actual time=0.010..956.457 rows=1000000 loops=1) Filter: (fs_batchid = 1)
5.	23.830	64.882	↑ 1.0	45351	1	→ Hash (cost=1787.51..1787.51 rows=45351 width=66) (actual time=64.882..64.882 rows=45351 loops=1)
6.	41.052	41.052	↑ 1.0	45351	1	→ Seq Scan on fs_agrperson (cost=0.00..1787.51 rows=45351 width=66) (actual time=0.018..41.052 rows=45351 loops=1)
7.	84.663	1323.470	↓ 23.3	1038059	1	→ Materialize (cost=92733.09..93289.59 rows=44520 width=66) (actual time=1087.679..1323.470 rows=1038059 loops=1)
8.	845.809	1238.807	↑ 1.2	38060	1	→ Sort (cost=92733.09..92844.39 rows=44520 width=66) (actual time=1087.676..1238.807 rows=38060 loops=1) Sort Key: fs_debtitem.fs_party Sort Method: external merge Disk: 3344kB
9.	392.998	392.998	↓ 1.0	45351	1	→ Seq Scan on fs_debtitem (cost=0.00..87468.66 rows=44520 width=66) (actual time=64.710..392.998 rows=45351 loops=1) Filter: (fs_annualize = 0)

"Merge Join  (cost=1398900.98..1419034.34 rows=980110 width=599) (actual time=15145.778..19802.139 rows=1000000 loops=1)"
"  Merge Cond: ((fs_agrperson.fs_party)::text = (fs_debtitem.fs_party)::text)"
"  ->  Sort  (cost=1306165.01..1308661.03 rows=998405 width=533) (actual time=13864.657..14234.234 rows=1000000 loops=1)"
"        Sort Key: fs_agrperson.fs_party"
"        Sort Method:  external sort  Disk: 306952kB"
"        ->  Hash Join  (cost=2886.40..251163.62 rows=998405 width=533) (actual time=64.913..1608.810 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..956.457 rows=1000000 loops=1)"
"                    Filter: (fs_batchid = 1)"
"              ->  Hash  (cost=1787.51..1787.51 rows=45351 width=66) (actual time=64.882..64.882 rows=45351 loops=1)"
"                    ->  Seq Scan on fs_agrperson  (cost=0.00..1787.51 rows=45351 width=66) (actual time=0.018..41.052 rows=45351 loops=1)"
"  ->  Materialize  (cost=92733.09..93289.59 rows=44520 width=66) (actual time=1087.679..1323.470 rows=1038059 loops=1)"
"        ->  Sort  (cost=92733.09..92844.39 rows=44520 width=66) (actual time=1087.676..1238.807 rows=38060 loops=1)"
"              Sort Key: fs_debtitem.fs_party"
"              Sort Method:  external merge  Disk: 3344kB"
"              ->  Seq Scan on fs_debtitem  (cost=0.00..87468.66 rows=44520 width=66) (actual time=64.710..392.998 rows=45351 loops=1)"
"                    Filter: (fs_annualize = 0)"
"Total runtime: 20029.673 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	1	23.830 ms	0.1 %
Hash Join	1	587.471 ms	3.0 %
Materialize	1	84.663 ms	0.4 %
Merge Join	1	4244.435 ms	21.4 %
Seq Scan	3	1390.507 ms	7.0 %
Sort	2	13471.233 ms	68.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cm_ledgeritem	1	956.457 ms	4.8 %
Seq Scan	1	956.457 ms	100.0 %
fs_agrperson	1	41.052 ms	0.2 %
Seq Scan	1	41.052 ms	100.0 %
fs_debtitem	1	392.998 ms	2.0 %
Seq Scan	1	392.998 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: omN

Colorize:

Columns visibility:

Per node type stats

Per table stats