explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Irf9

Settings
# exclusive inclusive rows x rows loops node
1. 42.942 1,123.462 ↓ 1.0 9,015 1

Sort (cost=7,167.58..7,189.96 rows=8,955 width=200) (actual time=1,122.785..1,123.462 rows=9,015 loops=1)

  • Sort Key: ga.gl_group_type_id, gat.formatted_account_number
  • Sort Method: quicksort Memory: 2781kB
  • Buffers: shared hit=90 read=1265
2. 1,033.774 1,080.520 ↓ 1.0 9,015 1

Hash Join (cost=391.49..6,579.75 rows=8,955 width=200) (actual time=9.893..1,080.52 rows=9,015 loops=1)

  • Buffers: shared hit=84 read=1265
3. 7.226 46.302 ↓ 1.0 9,015 1

Hash Join (cost=389.38..2,056.7 rows=8,955 width=392) (actual time=6.356..46.302 rows=9,015 loops=1)

  • Buffers: shared hit=16 read=1258
4. 33.460 33.460 ↓ 1.0 9,015 1

Seq Scan on gl_account_trees gat (cost=0..1,643.8 rows=8,957 width=272) (actual time=0.651..33.46 rows=9,015 loops=1)

  • Filter: ((gat.cid = 15573) AND (gat.is_default = 1))
  • Buffers: shared hit=2 read=1108
5. 2.050 5.616 ↑ 1.0 9,015 1

Hash (cost=276.69..276.69 rows=9,015 width=128) (actual time=5.616..5.616 rows=9,015 loops=1)

  • Buffers: shared hit=14 read=150
6. 3.566 3.566 ↑ 1.0 9,015 1

Seq Scan on gl_accounts ga (cost=0..276.69 rows=9,015 width=128) (actual time=0.015..3.566 rows=9,015 loops=1)

  • Filter: ((ga.disabled_on IS NULL) AND (ga.cid = 15573))
  • Buffers: shared hit=14 read=150
7. 0.014 0.444 ↑ 1.0 5 1

Hash (cost=2.05..2.05 rows=5 width=496) (actual time=0.444..0.444 rows=5 loops=1)

  • Buffers: shared hit=1 read=1
8. 0.430 0.430 ↑ 1.0 5 1

Seq Scan on gl_group_types glgt (cost=0..2.05 rows=5 width=496) (actual time=0.427..0.43 rows=5 loops=1)

  • Buffers: shared hit=1 read=1
Planning time : 19.246 ms
Execution time : 1,124.165 ms