explain.depesz.com

PostgreSQL's explain analyze made readable

Result: upWY

Settings
# exclusive inclusive rows x rows loops node
1. 0.144 40.830 ↓ 5.0 30 1

Sort (cost=101.18..101.20 rows=6 width=112) (actual time=40.809..40.830 rows=30 loops=1)

  • Sort Key: sg_con_m1.sg_con_status, sg_con_m1.sg_con_contract
  • Sort Method: quicksort Memory: 30kB
2. 0.129 40.686 ↓ 5.0 30 1

Nested Loop Left Join (cost=0.00..101.10 rows=6 width=112) (actual time=17.379..40.686 rows=30 loops=1)

3. 0.059 39.832 ↓ 25.0 25 1

Limit (cost=0.00..93.79 rows=1 width=82) (actual time=17.327..39.832 rows=25 loops=1)

4. 0.127 39.773 ↓ 25.0 25 1

Nested Loop Semi Join (cost=0.00..93.79 rows=1 width=82) (actual time=17.325..39.773 rows=25 loops=1)

5. 0.173 39.446 ↓ 25.0 25 1

Nested Loop (cost=0.00..89.47 rows=1 width=82) (actual time=17.287..39.446 rows=25 loops=1)

6. 38.598 38.598 ↓ 25.0 25 1

Index Scan using sg_con_m105 on sg_con_m1 (cost=0.00..85.14 rows=1 width=91) (actual time=17.232..38.598 rows=25 loops=1)

  • Index Cond: ((sg_con_alpha ~>=~ 'SHAH'::bpchar) AND (sg_con_alpha ~<~ 'SHAI'::bpchar))
  • Filter: (((sg_con_fname)::text ~~ 'PRATIK%'::text) AND (sg_con_alpha ~~ 'SHAH%'::text))
7. 0.675 0.675 ↑ 1.0 1 25

Index Scan using sg_dlr_m1_pkey on sg_dlr_m1 (cost=0.00..4.29 rows=1 width=9) (actual time=0.025..0.027 rows=1 loops=25)

  • Index Cond: (sg_dlr_dealer = sg_con_m1.sg_con_dealer)
8. 0.200 0.200 ↑ 1.0 1 25

Index Scan using sg_plc_m1_pkey on sg_plc_m1 (cost=0.00..4.29 rows=1 width=5) (actual time=0.008..0.008 rows=1 loops=25)

  • Index Cond: (sg_plc_plc = (sg_con_m1.sg_con_plc)::bpchar)
9. 0.725 0.725 ↓ 0.0 0 25

Index Scan using sg_clm_m101 on sg_clm_m1 (cost=0.00..7.09 rows=6 width=41) (actual time=0.028..0.029 rows=0 loops=25)

  • Index Cond: (sg_clm_contract = sg_con_m1.sg_con_contract)