explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gE2

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.056 ↓ 0.0 0 1

Subquery Scan on s (cost=30.34..30.66 rows=1 width=227) (actual time=0.056..0.056 rows=0 loops=1)

  • Filter: (s.rnk = 1)
2. 0.000 0.055 ↓ 0.0 0 1

WindowAgg (cost=30.34..30.57 rows=7 width=303) (actual time=0.055..0.055 rows=0 loops=1)

3. 0.013 0.055 ↓ 0.0 0 1

Sort (cost=30.34..30.36 rows=7 width=177) (actual time=0.054..0.055 rows=0 loops=1)

  • Sort Key: ba.ban, ba.commit_dttm DESC, ba.log_position_number DESC, ba.load_dttm DESC
  • Sort Method: quicksort Memory: 25kB
4. 0.007 0.042 ↓ 0.0 0 1

Hash Join (cost=11.10..30.24 rows=7 width=177) (actual time=0.042..0.042 rows=0 loops=1)

  • Hash Cond: ((cc.credit_class)::text = (ba.credit_class)::text)
5. 0.011 0.011 ↑ 660.0 1 1

Seq Scan on lkp_credit_class cc (cost=0.00..16.60 rows=660 width=86) (actual time=0.011..0.011 rows=1 loops=1)

6. 0.001 0.024 ↓ 0.0 0 1

Hash (cost=11.07..11.07 rows=2 width=95) (actual time=0.024..0.024 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
7. 0.006 0.023 ↓ 0.0 0 1

Hash Join (cost=9.47..11.07 rows=2 width=95) (actual time=0.023..0.023 rows=0 loops=1)

  • Hash Cond: (btrim((cct.credit_class)::text) = btrim((ba.credit_class)::text))
8. 0.006 0.006 ↑ 36.0 1 1

Seq Scan on credit_class_type cct (cost=0.00..1.36 rows=36 width=9) (actual time=0.006..0.006 rows=1 loops=1)

9. 0.000 0.011 ↓ 0.0 0 1

Hash (cost=9.44..9.44 rows=2 width=88) (actual time=0.011..0.011 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
10. 0.000 0.011 ↓ 0.0 0 1

Append (cost=0.42..9.44 rows=2 width=88) (actual time=0.011..0.011 rows=0 loops=1)

11. 0.009 0.009 ↓ 0.0 0 1

Index Scan using idx_test on l_billing_account ba (cost=0.42..8.44 rows=1 width=43) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((load_dttm >= '2020-04-04 00:00:00'::timestamp without time zone) AND (load_dttm <= '2020-04-05 00:00:00'::timestamp without time zone))
12. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on l_billing_account_y2020m04begin ba_1 (cost=0.00..1.00 rows=1 width=134) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((load_dttm >= '2020-04-04 00:00:00'::timestamp without time zone) AND (load_dttm <= '2020-04-05 00:00:00'::timestamp without time zone))