explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NdYk

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.082 ↑ 1.0 1 1

Nested Loop (cost=2.60..8.70 rows=1 width=402) (actual time=0.071..0.082 rows=1 loops=1)

2. 0.000 0.072 ↑ 1.0 1 1

Nested Loop (cost=2.46..6.53 rows=1 width=310) (actual time=0.061..0.072 rows=1 loops=1)

3. 0.027 0.062 ↑ 1.0 1 1

Hash Join (cost=2.46..5.30 rows=1 width=168) (actual time=0.052..0.062 rows=1 loops=1)

  • Hash Cond: ((c.collections_channel)::text = (ca.collections_channel)::text)
4. 0.019 0.019 ↑ 1.9 31 1

Seq Scan on channel c (cost=0.00..2.60 rows=60 width=122) (actual time=0.008..0.019 rows=31 loops=1)

5. 0.005 0.016 ↑ 1.0 1 1

Hash (cost=2.45..2.45 rows=1 width=52) (actual time=0.016..0.016 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.011 0.011 ↑ 1.0 1 1

Index Scan using customer_account_pk on customer_account ca (cost=0.43..2.45 rows=1 width=52) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (account_id = 4878050)
7. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on sor_master sor (cost=0.00..1.23 rows=1 width=142) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: ((sor_name)::text = 'US'::text)
  • Rows Removed by Filter: 17
8. 0.004 0.004 ↑ 1.0 1 1

Index Scan using org_ledger_pk on org_ledger ol (cost=0.14..2.16 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (org_ledger_id = sor.sor_org_ledgerid)