explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9BZr

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.036 ↑ 1.0 1 1

Nested Loop (cost=0.57..8.62 rows=1 width=402) (actual time=0.032..0.036 rows=1 loops=1)

2. 0.000 0.031 ↑ 1.0 1 1

Nested Loop (cost=0.43..6.45 rows=1 width=310) (actual time=0.027..0.031 rows=1 loops=1)

3. 0.000 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.43..5.21 rows=1 width=168) (actual time=0.022..0.025 rows=1 loops=1)

4. 0.014 0.014 ↑ 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.014..0.014 rows=1 loops=1)

  • Index Cond: (account_id = 4878050)
  • Filter: ((collections_channel)::text = 'AWSCC'::text)
5. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on channel c (cost=0.00..2.75 rows=1 width=122) (actual time=0.008..0.011 rows=1 loops=1)

  • Filter: ((collections_channel)::text = 'AWSCC'::text)
  • Rows Removed by Filter: 30
6. 0.006 0.006 ↑ 1.0 1 1

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

  • Filter: ((sor_name)::text = 'US'::text)
  • Rows Removed by Filter: 17
7. 0.003 0.003 ↑ 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.003..0.003 rows=1 loops=1)

  • Index Cond: (org_ledger_id = sor.sor_org_ledgerid)