explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UeNg

Settings
# exclusive inclusive rows x rows loops node
1. 40.564 11,689.097 ↓ 601.2 55,908 1

Subquery Scan on accounts (cost=22,435.20..191,230.77 rows=93 width=530) (actual time=1,551.612..11,689.097 rows=55,908 loops=1)

  • Filter: (accounts."InstanceNumber" = 1)
2. 10,032.851 11,648.533 ↓ 3.0 55,908 1

WindowAgg (cost=22,435.20..190,997.82 rows=18,636 width=1,130) (actual time=1,551.608..11,648.533 rows=55,908 loops=1)

3. 710.471 1,615.682 ↓ 3.0 55,908 1

Sort (cost=22,435.20..22,481.79 rows=18,636 width=253) (actual time=1,551.091..1,615.682 rows=55,908 loops=1)

  • Sort Key: x."AccountNumber
  • Sort Method: external merge Disk: 13992kB
4. 43.456 905.211 ↓ 3.0 55,908 1

Nested Loop (cost=3,226.02..21,113.36 rows=18,636 width=253) (actual time=120.646..905.211 rows=55,908 loops=1)

5. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on "StandardTemplateParameters" parameters (cost=0.00..1.01 rows=1 width=0) (actual time=0.018..0.019 rows=1 loops=1)

6. 41.058 861.736 ↓ 3.0 55,908 1

Hash Left Join (cost=3,226.02..20,925.99 rows=18,636 width=209) (actual time=120.623..861.736 rows=55,908 loops=1)

  • Hash Cond: ((x."ServiceCode")::text = (services."ServiceCode")::text)
7. 63.978 820.610 ↓ 3.0 55,908 1

Hash Join (cost=3,221.85..20,572.54 rows=18,636 width=192) (actual time=120.535..820.610 rows=55,908 loops=1)

  • Hash Cond: ((x."CustomerNumber")::text = (newest."CustomerNumber")::text)
8. 93.943 666.674 ↓ 3.0 55,908 1

Hash Join (cost=1,610.93..18,705.37 rows=18,636 width=180) (actual time=30.217..666.674 rows=55,908 loops=1)

  • Hash Cond: ((x."CustomerNumber")::text = (allinstances."CustomerNumber")::text)
9. 543.143 543.143 ↓ 3.0 55,909 1

Seq Scan on "CoreDeposits" x (cost=0.00..16,838.20 rows=18,636 width=175) (actual time=0.236..543.143 rows=55,909 loops=1)

  • Filter: (ufn_parsedate(("OpenDate")::text, 'YYYY-MM-DD'::text, ''::text, (CURRENT_DATE)::text) <= CURRENT_DATE)
10. 13.474 29.588 ↑ 1.0 46,477 1

Hash (cost=1,029.96..1,029.96 rows=46,477 width=5) (actual time=29.588..29.588 rows=46,477 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2231kB
11. 16.114 16.114 ↑ 1.0 46,477 1

Seq Scan on "StandardTemplateCustomerInstances" allinstances (cost=0.00..1,029.96 rows=46,477 width=5) (actual time=0.014..16.114 rows=46,477 loops=1)

  • Filter: ("InstanceType" <> 'Duplicate'::text)
12. 14.834 89.958 ↑ 1.0 46,477 1

Hash (cost=1,029.96..1,029.96 rows=46,477 width=22) (actual time=89.958..89.958 rows=46,477 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3022kB
13. 75.124 75.124 ↑ 1.0 46,477 1

Seq Scan on "StandardTemplateCustomerInstances" newest (cost=0.00..1,029.96 rows=46,477 width=22) (actual time=0.018..75.124 rows=46,477 loops=1)

  • Filter: ("InstanceType" = 'Newest'::text)
14. 0.019 0.068 ↑ 1.0 40 1

Hash (cost=3.67..3.67 rows=40 width=21) (actual time=0.068..0.068 rows=40 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
15. 0.049 0.049 ↑ 1.0 40 1

Seq Scan on "BankServices" services (cost=0.00..3.67 rows=40 width=21) (actual time=0.027..0.049 rows=40 loops=1)

  • Filter: (("BankId" = 1) AND (("ServiceType")::text = 'Core Deposit'::text))
  • Rows Removed by Filter: 71
Planning time : 3.527 ms