explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D7Hk

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 1,925.594 ↓ 0.0 0 1

Sort (cost=509,009.27..509,009.28 rows=1 width=112) (actual time=1,925.594..1,925.594 rows=0 loops=1)

  • Sort Key: sg_con_m1.sg_con_status, sg_con_m1.sg_con_contract
  • Sort Method: quicksort Memory: 25kB
2. 0.002 1,925.578 ↓ 0.0 0 1

Nested Loop (cost=0.00..509,009.26 rows=1 width=112) (actual time=1,925.578..1,925.578 rows=0 loops=1)

3. 0.009 1,925.576 ↓ 0.0 0 1

Nested Loop (cost=0.00..509,005.08 rows=1 width=121) (actual time=1,925.576..1,925.576 rows=0 loops=1)

  • Join Filter: (public.sg_clm_m1.sg_clm_contract = sg_con_m1.sg_con_contract)
4. 0.004 1,925.491 ↑ 555.0 1 1

Limit (cost=0.00..507,802.34 rows=555 width=391) (actual time=1,895.370..1,925.491 rows=1 loops=1)

5. 1,925.487 1,925.487 ↑ 555.0 1 1

Seq Scan on sg_clm_m1 (cost=0.00..507,802.34 rows=555 width=391) (actual time=1,895.368..1,925.487 rows=1 loops=1)

  • Filter: (sg_clm_claim ~~ '%8082912%'::text)
6. 0.012 0.076 ↑ 18.3 3 1

Materialize (cost=0.00..117.85 rows=55 width=91) (actual time=0.064..0.076 rows=3 loops=1)

7. 0.064 0.064 ↑ 18.3 3 1

Index Scan using sg_con_m1_vin on sg_con_m1 (cost=0.00..117.57 rows=55 width=91) (actual time=0.057..0.064 rows=3 loops=1)

  • Index Cond: ((sg_con_vin)::text = '5J8TB3H70HL013482'::text)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using sg_dlr_m1_pkey on sg_dlr_m1 (cost=0.00..4.15 rows=1 width=9) (never executed)

  • Index Cond: (sg_dlr_dealer = sg_con_m1.sg_con_dealer)