explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4QVs

Settings
# exclusive inclusive rows x rows loops node
1. 49.405 888.873 ↓ 1.0 9,018 1

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

  • Sort Key: ga.gl_group_type_id, gat.formatted_account_number
  • Sort Method: quicksort Memory: 2,781kB
  • Buffers: shared hit=2,184
2. 808.272 839.468 ↓ 1.0 9,018 1

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

  • Hash Cond: (ga.gl_group_type_id = glgt.id)
  • Buffers: shared hit=2,178
3. 9.401 31.172 ↓ 1.0 9,018 1

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

  • Hash Cond: (gat.gl_account_id = ga.id)
  • Buffers: shared hit=2,041
4. 5.255 16.799 ↓ 1.0 9,018 1

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

  • Buffers: shared hit=1,877
5. 0.007 0.007 ↑ 1.0 1 1

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

  • Filter: ((cid = 15,573) AND (is_system = 1) AND ((system_code)::text = 'DEFAULT'::text))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=1
6. 11.537 11.537 ↓ 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.038..11.537 rows=9,018 loops=1)

  • Index Cond: ((cid = 15,573) AND (gl_tree_id = gt.id))
  • Buffers: shared hit=1,876
7. 1.970 4.972 ↑ 1.0 9,018 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,457kB
  • Buffers: shared hit=164
8. 3.002 3.002 ↑ 1.0 9,018 1

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

  • Filter: ((disabled_on IS NULL) AND (cid = 15,573))
  • Buffers: shared hit=164
9. 0.011 0.024 ↑ 1.0 5 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
10. 0.013 0.013 ↑ 1.0 5 1

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

  • Buffers: shared hit=2
Planning time : 3.021 ms
Execution time : 890.260 ms