explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7LC0

Settings
# exclusive inclusive rows x rows loops node
1. 2,067.513 9,166.996 ↓ 7.5 10,824,100 1

Unique (cost=1,598,611.98..1,652,778.82 rows=1,438,174 width=8) (actual time=5,194.265..9,166.996 rows=10,824,100 loops=1)

  • Output: gl_business_unit_and_journal_id_computed
  • Buffers: shared hit=41,574, temp read=23,853 written=23,883
  • Functions: 3
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.437 ms, Inlining 4.033 ms, Optimization 15.066 ms, Emission 15.315 ms, Total 34.851 ms
2. 5,506.241 7,099.483 ↑ 1.0 10,824,109 1

Sort (cost=1,598,611.98..1,625,695.40 rows=10,833,367 width=8) (actual time=5,194.263..7,099.483 rows=10,824,109 loops=1)

  • Output: gl_business_unit_and_journal_id_computed
  • Sort Key: gl.gl_business_unit_and_journal_id_computed
  • Sort Method: external merge Disk: 190,824kB
  • Buffers: shared hit=41,574, temp read=23,853 written=23,883
3. 1,593.242 1,593.242 ↑ 1.0 10,824,109 1

Index Only Scan using ap_8f017835_bc79_4f46_adfb_44_ca_fs_caption_gl_business_uni_idx on public.ap_8f017835_bc79_4f46_adfb_449b9d338d34_mega_gl gl (cost=0.56..246,036.49 rows=10,833,367 width=8) (actual time=34.548..1,593.242 rows=10,824,109 loops=1)

  • Output: gl_business_unit_and_journal_id_computed
  • Index Cond: (gl.ca_fs_caption = 'Cash'::text)
  • Heap Fetches: 0
  • Buffers: shared hit=41,574
Execution time : 9,699.916 ms