explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vXYR

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.144 ↑ 7.0 1 1

HashAggregate (cost=837.68..837.75 rows=7 width=32) (actual time=0.144..0.144 rows=1 loops=1)

  • Total runtime: 0.259 ms
2. 0.012 0.129 ↑ 19.7 3 1

Nested Loop (cost=1.12..837.09 rows=59 width=32) (actual time=0.071..0.129 rows=3 loops=1)

3. 0.036 0.036 ↑ 22.0 3 1

Index Scan using bcc_claim_activity_id_idx on bill_charge_claim bcc (cost=0.56..269.65 rows=66 width=35) (actual time=0.034..0.036 rows=3 loops=1)

  • Index Cond: ((claim_activity_id)::text = 'ACT-CH25109959'::text)
4. 0.081 0.081 ↑ 1.0 1 3

Index Scan using bill_charge_pkey on bill_charge bc (cost=0.56..8.59 rows=1 width=17) (actual time=0.026..0.027 rows=1 loops=3)

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