explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QDzS : Optimization for: plan #EAKh

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 7.304 7.304 ↓ 0.0 0 1

Index Scan using case_doc_ver_pkey on case_document_version casedocume0_ (cost=0.83..109.46 rows=6 width=132) (actual time=7.304..7.304 rows=0 loops=1)

  • Index Cond: ((case_file_id = '5286808707'::bigint) AND ((file_name)::text = ANY ('{LoanApplication.xml0,LoanApplication.xml1,LoanApplication.xml2,LoanApplication.xml3,LoanApplication.xml4,LoanApplication.xml5,LoanApplication.xml6,LoanApplication.xml7,LoanApplication.xml8,LoanApplication.xml9,LoanApplication.xml10,LoanApplication.xml11,LoanApplication.xml12,LoanApplication.xml13,LoanApplication.xml14,LoanApplication.xml15,LoanApplication.xml16}'::text[])))
  • Filter: (delete_status = 0)
Planning time : 1.381 ms
Execution time : 7.323 ms