explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Ljz : CIS Mthly Rtn

options
# exclusive inclusive rows x rows loops node
1. 3.259 42.199 ↑ 1.0 3400 1
→

Sort (cost=123004.91..123013.47 rows=3424 width=122) (actual time=41.983..42.199 rows=3400 loops=1)

  • Sort Key: femtrnsr.mthly_rtn_id
  • Sort Method: quicksort Memory: 1000kB
2.          

Initplan (forSort)
3. 0.005 0.005 ↓ 0.0 0 1
→

Index Scan using ft_ercrdetails_p on ft_er_cr_details (cost=0.00..8.27 rows=1 width=17) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (er_batch_id = 2296)
  • Filter: (er_id = 1)
4. 7.273 38.935 ↑ 1.0 3400 1
→

Nested Loop (cost=0.00..122795.63 rows=3424 width=122) (actual time=0.082..38.935 rows=3400 loops=1)

5. 0.004 0.028 ↑ 1.0 1 1
→

Nested Loop (cost=0.00..16.55 rows=1 width=54) (actual time=0.027..0.028 rows=1 loops=1)

6. 0.011 0.011 ↑ 1.0 1 1
→

Index Scan using cs_crheader_p1 on cs_cr_header fecr (cost=0.00..8.27 rows=1 width=31) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (er_batch_id = 2296)
7. 0.013 0.013 ↑ 1.0 1 1
→

Index Scan using ft_ercsv_p on ft_er_csv fecsv (cost=0.00..8.27 rows=1 width=27) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (er_batch_id = 2296)
  • Filter: (er_id = 1)
8. 1.034 1.034 ↑ 1.0 3400 1
→

Index Scan using cs_srmthrtn_p1 on cs_sr_mthly_rtn femtrnsr (cost=0.00..159.40 rows=3424 width=72) (actual time=0.019..1.034 rows=3400 loops=1)

  • Index Cond: (er_batch_id = 2296)
9.          

SubPlan (forNested Loop)
10. 0.000 0.000 ↓ 0.0 0 3400
→

Index Scan using ft_erefildet_p on ft_er_efiling_details (cost=0.00..8.27 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=3400)

  • Index Cond: (er_efiling_id = fecsv.er_efiling_id)
11. 0.000 0.000 ↓ 0.0 0 3400
→

Index Scan using ft_erefildet_p on ft_er_efiling_details (cost=0.00..8.27 rows=1 width=33) (actual time=0.000..0.000 rows=0 loops=3400)

  • Index Cond: (er_efiling_id = fecsv.er_efiling_id)
12. 0.000 0.000 ↓ 0.0 0 3400
→

Index Scan using ft_efresp_p on ft_ef_response (cost=0.00..8.27 rows=1 width=10) (actual time=0.000..0.000 rows=0 loops=3400)

  • Index Cond: (er_efiling_id = fecsv.er_efiling_id)
13. 3.400 3.400 ↓ 0.0 0 3400
→

Index Scan using cs_sr_det_p on cs_sr_details (cost=0.00..8.27 rows=1 width=2) (actual time=0.001..0.001 rows=0 loops=3400)

  • Index Cond: (mthly_rtn_id = femtrnsr.mthly_rtn_id)
  • Filter: (er_batch_id = 2296)
14. 27.200 27.200 ↓ 0.0 0 3400
→

Seq Scan on cis_subcontractors (cost=0.00..2.73 rows=1 width=2) (actual time=0.008..0.008 rows=0 loops=3400)

  • Filter: ((sc_utr)::text = (femtrnsr.sr_utr)::text)