explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7zh

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.747 ↑ 1.0 1 1

Subquery Scan on foo (cost=1,362.65..1,362.67 rows=1 width=11) (actual time=0.746..0.747 rows=1 loops=1)

  • Total runtime: 0.908 ms
2. 0.030 0.744 ↑ 1.0 1 1

HashAggregate (cost=1,362.65..1,362.66 rows=1 width=23) (actual time=0.744..0.744 rows=1 loops=1)

  • Filter: (sum((bc.act_quantity + bc.return_qty)) <> rsd.quantity)
  • Rows Removed by Filter: 1
3. 0.019 0.714 ↓ 7.0 7 1

Nested Loop (cost=11.87..1,362.64 rows=1 width=23) (actual time=0.467..0.714 rows=7 loops=1)

4. 0.017 0.548 ↓ 7.0 7 1

Nested Loop (cost=11.31..1,359.47 rows=1 width=26) (actual time=0.434..0.548 rows=7 loops=1)

5. 0.347 0.347 ↑ 10.5 2 1

Index Scan using idx_ra_stg_detials_file_id on ra_stg_details rsd (cost=0.56..1,049.23 rows=21 width=21) (actual time=0.305..0.347 rows=2 loops=1)

  • Index Cond: ((file_id)::text = 'T00000000074806'::text)
  • Filter: ((payment_amount > 0::numeric) AND (is_combined = 'Y'::bpchar) AND ((charge_type)::text = 'A'::text))
  • Rows Removed by Filter: 319
6. 0.020 0.184 ↓ 4.0 4 2

Bitmap Heap Scan on bill_charge_claim bcc (cost=10.75..14.76 rows=1 width=35) (actual time=0.089..0.092 rows=4 loops=2)

  • Recheck Cond: (((claim_activity_id)::text = (rsd.group_charge)::text) AND ((claim_id)::text = (rsd.claim_id)::text))
7. 0.010 0.164 ↓ 0.0 0 2

BitmapAnd (cost=10.75..10.75 rows=1 width=0) (actual time=0.082..0.082 rows=0 loops=2)

8. 0.076 0.076 ↑ 16.5 4 2

Bitmap Index Scan on bcc_claim_activity_id_idx (cost=0.00..5.06 rows=66 width=0) (actual time=0.038..0.038 rows=4 loops=2)

  • Index Cond: ((claim_activity_id)::text = (rsd.group_charge)::text)
9. 0.078 0.078 ↑ 3.2 37 2

Bitmap Index Scan on bill_charge_claim_claim_idx (cost=0.00..5.44 rows=117 width=0) (actual time=0.039..0.039 rows=37 loops=2)

  • Index Cond: ((claim_id)::text = (rsd.claim_id)::text)
10. 0.147 0.147 ↑ 1.0 1 7

Index Scan using bill_charge_pkey on bill_charge bc (cost=0.56..3.16 rows=1 width=17) (actual time=0.021..0.021 rows=1 loops=7)

  • Index Cond: ((charge_id)::text = (bcc.charge_id)::text)
  • Filter: ((status <> 'X'::bpchar) AND (act_quantity > 0::numeric))