explain.depesz.com

PostgreSQL's explain analyze made readable

Result: suVO

Settings
# exclusive inclusive rows x rows loops node
1. 43.195 58.188 ↓ 1.0 9,018 1

Sort (cost=2,770.19..2,792.44 rows=8,899 width=136) (actual time=57.439..58.188 rows=9,018 loops=1)

  • Sort Key: ga.gl_group_type_id, gat.formatted_account_number
  • Sort Method: quicksort Memory: 2608kB
  • Buffers: shared hit=2049
2. 2.426 14.993 ↓ 1.0 9,018 1

Hash Join (cost=752.77..2,186.44 rows=8,899 width=136) (actual time=3.439..14.993 rows=9,018 loops=1)

  • Hash Cond: (ga.gl_group_type_id = glgt.id)
  • Buffers: shared hit=2043
3. 4.061 12.558 ↓ 1.0 9,018 1

Hash Join (cost=750.46..2,105.37 rows=8,899 width=136) (actual time=3.424..12.558 rows=9,018 loops=1)

  • Hash Cond: (gat.gl_account_id = ga.id)
  • Buffers: shared hit=2041
4. 2.010 5.118 ↓ 1.0 9,018 1

Nested Loop (cost=0.29..1,331.81 rows=8,899 width=16) (actual time=0.019..5.118 rows=9,018 loops=1)

  • Buffers: shared hit=1877
5. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on gl_trees gt (cost=0.00..1.15 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

  • Filter: ((cid = 15573) AND (is_system = 1) AND ((system_code)::text = 'DEFAULT'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1
6. 3.103 3.103 ↓ 1.0 9,018 1

Index Scan using uk_gl_account_trees_gl_account_id on gl_account_trees gat (cost=0.29..1,063.69 rows=8,899 width=20) (actual time=0.014..3.103 rows=9,018 loops=1)

  • Index Cond: ((cid = 15573) AND (gl_tree_id = gt.id))
  • Buffers: shared hit=1876
7. 1.128 3.379 ↑ 1.0 9,018 1

Hash (cost=457.09..457.09 rows=9,018 width=128) (actual time=3.379..3.379 rows=9,018 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1457kB
  • Buffers: shared hit=164
8. 2.251 2.251 ↑ 1.0 9,018 1

Seq Scan on gl_accounts ga (cost=0.00..457.09 rows=9,018 width=128) (actual time=0.005..2.251 rows=9,018 loops=1)

  • Filter: ((disabled_on IS NULL) AND (cid = 15573))
  • Buffers: shared hit=164
9. 0.003 0.009 ↑ 1.0 5 1

Hash (cost=2.15..2.15 rows=5 width=4) (actual time=0.009..0.009 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
10. 0.006 0.006 ↑ 1.0 5 1

Seq Scan on gl_group_types glgt (cost=0.00..2.15 rows=5 width=4) (actual time=0.004..0.006 rows=5 loops=1)

  • Buffers: shared hit=2
Planning time : 1.729 ms
Execution time : 58.881 ms