explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y2J

Settings
# exclusive inclusive rows x rows loops node
1. 43.809 1,181.877 ↓ 1.0 9,015 1

Sort (cost=7,095.69..7,117.93 rows=8,895 width=200) (actual time=1,181.195..1,181.877 rows=9,015 loops=1)

  • Sort Key: ga.gl_group_type_id, gat.formatted_account_number
  • Sort Method: quicksort Memory: 2,781kB
  • Buffers: shared hit=86 read=682
2. 1,067.650 1,138.068 ↓ 1.0 9,015 1

Hash Join (cost=664.73..6,512.23 rows=8,895 width=200) (actual time=51.47..1,138.068 rows=9,015 loops=1)

  • Buffers: shared hit=80 read=682
3. 7.336 70.018 ↓ 1.0 9,015 1

Hash Join (cost=662.62..2,019.48 rows=8,895 width=392) (actual time=45.027..70.018 rows=9,015 loops=1)

  • Buffers: shared hit=16 read=671
4. 3.902 55.186 ↓ 1.0 9,015 1

Nested Loop (cost=273.24..1,606.74 rows=8,897 width=272) (actual time=37.427..55.186 rows=9,015 loops=1)

  • Buffers: shared hit=3 read=520
5. 0.005 0.005 ↑ 1.0 1 1

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

  • Filter: ((gt.cid = 15,573) AND (gt.is_system = 1) AND ((gt.system_code)::text = 'DEFAULT'::text))
  • Buffers: shared hit=1
6. 14.478 51.279 ↓ 1.0 9,015 1

Bitmap Heap Scan on gl_account_trees gat (cost=273.24..1,516.7 rows=8,897 width=276) (actual time=37.42..51.279 rows=9,015 loops=1)

  • Filter: (gat.cid = 15,573)
  • Heap Blocks: exact=429
  • Buffers: shared hit=2 read=520
7. 36.801 36.801 ↓ 1.0 9,015 1

Bitmap Index Scan on idx_gl_account_trees_gl_tree_id (cost=0..271.02 rows=8,897 width=0) (actual time=36.801..36.801 rows=9,015 loops=1)

  • Index Cond: (gat.gl_tree_id = gt.id)
  • Buffers: shared read=93
8. 1.862 7.496 ↑ 1.0 9,015 1

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

  • Buffers: shared hit=13 read=151
9. 5.634 5.634 ↑ 1.0 9,015 1

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

  • Filter: ((ga.disabled_on IS NULL) AND (ga.cid = 15,573))
  • Buffers: shared hit=13 read=151
10. 0.011 0.400 ↑ 1.0 5 1

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

  • Buffers: shared hit=1 read=1
11. 0.389 0.389 ↑ 1.0 5 1

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

  • Buffers: shared hit=1 read=1
Planning time : 47.185 ms
Execution time : 1,182.563 ms