explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4z6x

Settings
# exclusive inclusive rows x rows loops node
1. 47.170 1,324.897 ↓ 1.0 9,017 1

Sort (cost=7,178.57..7,201 rows=8,972 width=200) (actual time=1,324.233..1,324.897 rows=9,017 loops=1)

  • Sort Key: ga.gl_group_type_id, gat.formatted_account_number
  • Sort Method: quicksort Memory: 2781kB
  • Buffers: shared hit=1356
2. 1,253.972 1,277.727 ↓ 1.0 9,017 1

Hash Join (cost=391.54..6,589.5 rows=8,972 width=200) (actual time=9.423..1,277.727 rows=9,017 loops=1)

  • Buffers: shared hit=1350
3. 7.228 23.740 ↓ 1.0 9,017 1

Hash Join (cost=389.42..2,057.88 rows=8,972 width=393) (actual time=5.385..23.74 rows=9,017 loops=1)

  • Buffers: shared hit=1275
4. 11.221 11.221 ↓ 1.0 9,017 1

Seq Scan on gl_account_trees gat (cost=0..1,644.89 rows=8,972 width=273) (actual time=0.005..11.221 rows=9,017 loops=1)

  • Filter: ((gat.cid = 15573) AND (gat.is_default = 1))
  • Buffers: shared hit=1111
5. 3.139 5.291 ↑ 1.0 9,017 1

Hash (cost=276.71..276.71 rows=9,017 width=128) (actual time=5.291..5.291 rows=9,017 loops=1)

  • Buffers: shared hit=164
6. 2.152 2.152 ↑ 1.0 9,017 1

Seq Scan on gl_accounts ga (cost=0..276.71 rows=9,017 width=128) (actual time=0.007..2.152 rows=9,017 loops=1)

  • Filter: ((ga.disabled_on IS NULL) AND (ga.cid = 15573))
  • Buffers: shared hit=164
7. 0.008 0.015 ↑ 1.0 5 1

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

  • Buffers: shared hit=2
8. 0.007 0.007 ↑ 1.0 5 1

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

  • Buffers: shared hit=2
Planning time : 1.887 ms
Execution time : 1,325.547 ms