explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HfjY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.025 ↓ 0.0 0 1

Update on fact_acct fact (cost=13.33..249.24 rows=7 width=1,482) (actual time=0.025..0.025 rows=0 loops=1)

2. 0.000 0.025 ↓ 0.0 0 1

Nested Loop (cost=13.33..249.24 rows=7 width=1,482) (actual time=0.025..0.025 rows=0 loops=1)

3. 0.000 0.025 ↓ 0.0 0 1

HashAggregate (cost=8.45..8.46 rows=1 width=39) (actual time=0.025..0.025 rows=0 loops=1)

4. 0.025 0.025 ↓ 0.0 0 1

Index Scan using fact_acct_table_record_id on fact_acct f (cost=0.42..8.45 rows=1 width=39) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (((ad_table_id)::text = ':tableId'::text) AND ((record_id)::text = ':transactions'::text))
  • Filter: ((ad_client_id)::text = ':clientId'::text)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on fact_acct fact (cost=4.88..240.71 rows=7 width=1,476) (never executed)

  • Recheck Cond: ((record_id2)::text = (f.record_id2)::text)
  • Filter: (datebalanced IS NOT NULL)
6. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on fact_acct_record_id2 (cost=0.00..4.88 rows=60 width=0) (never executed)

  • Index Cond: ((record_id2)::text = (f.record_id2)::text)