explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hFJo

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 343.346 343.346 ↓ 42.2 13,554 1

Index Scan using idx_gl_details_cid_gl_transaction_type_id on gl_details gd (cost=0.44..168,830.66 rows=321 width=21) (actual time=2.730..343.346 rows=13,554 loops=1)

  • Index Cond: ((cid = 14,108) AND (gl_transaction_type_id = 1))
  • Filter: ((job_phase_id IS NOT NULL) AND (reclass_gl_detail_id IS NULL))
  • Rows Removed by Filter: 334,597
Planning time : 2.003 ms
Execution time : 353.517 ms