explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7ach : Optimization for: plan #hFJo

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 15.543 68.355 ↓ 32.8 13,554 1

Bitmap Heap Scan on gl_details gd (cost=3,260.44..3,687.89 rows=413 width=21) (actual time=53.012..68.355 rows=13,554 loops=1)

  • Recheck Cond: ((job_phase_id IS NOT NULL) AND (cid = 14,108) AND (gl_transaction_type_id = 1))
  • Filter: (reclass_gl_detail_id IS NULL)
  • Heap Blocks: exact=1,210
2. 0.384 52.812 ↓ 0.0 0 1

BitmapAnd (cost=3,260.44..3,260.44 rows=413 width=0) (actual time=52.809..52.812 rows=0 loops=1)

3. 4.553 4.553 ↑ 1.2 44,071 1

Bitmap Index Scan on idx_gl_details_job_phase_id_partial (cost=0.00..384.80 rows=52,301 width=0) (actual time=4.553..4.553 rows=44,071 loops=1)

4. 47.875 47.875 ↓ 1.6 348,153 1

Bitmap Index Scan on idx_gl_details_cid_gl_transaction_type_id (cost=0.00..2,875.19 rows=213,575 width=0) (actual time=47.875..47.875 rows=348,153 loops=1)

  • Index Cond: ((cid = 14,108) AND (gl_transaction_type_id = 1))
Planning time : 2.253 ms
Execution time : 77.843 ms