explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0RrC

Settings
# exclusive inclusive rows x rows loops node
1. 42.425 1,142.468 ↓ 1.0 9,015 1

Sort (cost=7,192.53..7,215.02 rows=8,998 width=200) (actual time=1,141.813..1,142.468 rows=9,015 loops=1)

  • Sort Key: ga.gl_group_type_id, gat.formatted_account_number
  • Sort Method: quicksort Memory: 2781kB
  • Buffers: shared hit=84 read=1271
2. 1,041.746 1,100.043 ↓ 1.0 9,015 1

Hash Join (cost=391.49..6,601.57 rows=8,998 width=200) (actual time=17.164..1,100.043 rows=9,015 loops=1)

  • Buffers: shared hit=78 read=1271
3. 7.335 57.835 ↓ 1.0 9,015 1

Hash Join (cost=389.38..2,056.81 rows=8,998 width=393) (actual time=8.324..57.835 rows=9,015 loops=1)

  • Buffers: shared hit=17 read=1257
4. 42.652 42.652 ↓ 1.0 9,015 1

Seq Scan on gl_account_trees gat (cost=0..1,643.8 rows=8,998 width=273) (actual time=0.38..42.652 rows=9,015 loops=1)

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

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

  • Buffers: shared hit=15 read=149
6. 5.547 5.547 ↑ 1.0 9,015 1

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

  • Filter: ((ga.disabled_on IS NULL) AND (ga.cid = 15573))
  • Buffers: shared hit=15 read=149
7. 0.011 0.462 ↑ 1.0 5 1

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

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

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

  • Buffers: shared hit=1 read=1
Planning time : 42.425 ms
Execution time : 1,143.163 ms