explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qYEi

Settings
# exclusive inclusive rows x rows loops node
1. 0.073 0.509 ↓ 13.0 13 1

Sort (cost=6.60..6.61 rows=1 width=533) (actual time=0.508..0.509 rows=13 loops=1)

  • Sort Key: icm.insurance_co_name, tm.tpa_name
  • Sort Method: quicksort Memory: 26kB
2. 0.010 0.436 ↓ 13.0 13 1

Nested Loop (cost=1.51..6.59 rows=1 width=533) (actual time=0.117..0.436 rows=13 loops=1)

3. 0.028 0.283 ↓ 13.0 13 1

Nested Loop (cost=1.37..4.60 rows=1 width=512) (actual time=0.096..0.283 rows=13 loops=1)

  • Join Filter: ((icm.insurance_co_id)::text = (ictm.insurance_co_id)::text)
4. 0.041 0.150 ↓ 15.0 15 1

Nested Loop Semi Join (cost=1.24..3.73 rows=1 width=512) (actual time=0.063..0.150 rows=15 loops=1)

  • Join Filter: ((icm.insurance_co_id)::text = (insurance_category_master.insurance_co_id)::text)
  • Rows Removed by Join Filter: 162
5. 0.024 0.024 ↓ 17.0 17 1

Seq Scan on insurance_company_master icm (cost=0.00..1.21 rows=1 width=464) (actual time=0.013..0.024 rows=17 loops=1)

  • Filter: (status = 'A'::bpchar)
  • Rows Removed by Filter: 1
6. 0.023 0.085 ↓ 5.0 10 17

Materialize (cost=1.24..2.48 rows=2 width=48) (actual time=0.003..0.005 rows=10 loops=17)

7. 0.035 0.062 ↓ 9.0 18 1

Hash Semi Join (cost=1.24..2.47 rows=2 width=48) (actual time=0.046..0.062 rows=18 loops=1)

  • Hash Cond: (insurance_category_master.category_id = insurance_category_center_master.category_id)
8. 0.004 0.004 ↓ 1.1 19 1

Seq Scan on insurance_category_master (cost=0.00..1.17 rows=17 width=52) (actual time=0.002..0.004 rows=19 loops=1)

9. 0.010 0.023 ↓ 9.0 18 1

Hash (cost=1.21..1.21 rows=2 width=4) (actual time=0.023..0.023 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
10. 0.013 0.013 ↓ 9.0 18 1

Seq Scan on insurance_category_center_master (cost=0.00..1.21 rows=2 width=4) (actual time=0.005..0.013 rows=18 loops=1)

  • Filter: (center_id = ANY ('{7,0}'::integer[]))
  • Rows Removed by Filter: 1
11. 0.105 0.105 ↑ 1.0 1 15

Index Only Scan using insurance_company_tpa_master_pkey on insurance_company_tpa_master ictm (cost=0.14..0.86 rows=1 width=86) (actual time=0.007..0.007 rows=1 loops=15)

  • Index Cond: (insurance_co_id = (insurance_category_master.insurance_co_id)::text)
  • Heap Fetches: 13
12. 0.143 0.143 ↑ 1.0 1 13

Index Scan using tpa_master_pkey on tpa_master tm (cost=0.14..1.98 rows=1 width=31) (actual time=0.010..0.011 rows=1 loops=13)

  • Index Cond: ((tpa_id)::text = (ictm.tpa_id)::text)
  • Filter: (status = 'A'::bpchar)
Total runtime : 0.627 ms