explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8GS9

Settings
# exclusive inclusive rows x rows loops node
1. 0.105 0.510 ↓ 13.0 13 1

Sort (cost=4.39..4.39 rows=1 width=533) (actual time=0.508..0.510 rows=13 loops=1)

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

Nested Loop (cost=1.37..4.38 rows=1 width=533) (actual time=0.254..0.405 rows=13 loops=1)

3. 0.078 0.146 ↓ 13.0 13 1

Hash Join (cost=1.22..2.39 rows=1 width=512) (actual time=0.134..0.146 rows=13 loops=1)

  • Hash Cond: ((ictm.insurance_co_id)::text = (icm.insurance_co_id)::text)
4. 0.021 0.021 ↓ 1.2 13 1

Seq Scan on insurance_company_tpa_master ictm (cost=0.00..1.11 rows=11 width=86) (actual time=0.019..0.021 rows=13 loops=1)

5. 0.013 0.047 ↓ 17.0 17 1

Hash (cost=1.21..1.21 rows=1 width=464) (actual time=0.047..0.047 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
6. 0.034 0.034 ↓ 17.0 17 1

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

  • Filter: (status = 'A'::bpchar)
  • Rows Removed by Filter: 1
7. 0.221 0.221 ↑ 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.017..0.017 rows=1 loops=13)

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