explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aZrh

Settings
# exclusive inclusive rows x rows loops node
1. 48.128 811.423 ↓ 1.0 9,018 1

Sort (cost=7,219.69..7,241.94 rows=8,899 width=200) (actual time=810.504..811.423 rows=9,018 loops=1)

  • Sort Key: ga.gl_group_type_id, gat.formatted_account_number
  • Sort Method: quicksort Memory: 2781kB
  • Buffers: shared hit=2043
2. 739.543 763.295 ↓ 1.0 9,018 1

Hash Join (cost=752.77..6,635.94 rows=8,899 width=200) (actual time=3.895..763.295 rows=9,018 loops=1)

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

Hash Join (cost=750.46..2,105.37 rows=8,899 width=394) (actual time=3.519..23.740 rows=9,018 loops=1)

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

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

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

Seq Scan on gl_trees gt (cost=0.00..1.15 rows=1 width=8) (actual time=0.003..0.004 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. 7.380 7.380 ↓ 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=278) (actual time=0.014..7.380 rows=9,018 loops=1)

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

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

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

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

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

Hash (cost=2.15..2.15 rows=5 width=496) (actual time=0.012..0.012 rows=5 loops=1)

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

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

  • Buffers: shared hit=2
Planning time : 0.792 ms
Execution time : 812.134 ms