explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L8g

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 0.087 ↑ 1.0 1 1

Index Scan using mem_accounts_address_upper on mem_accounts a (cost=0.42..60.30 rows=1 width=733) (actual time=0.087..0.087 rows=1 loops=1)

  • Index Cond: (upper((address)::text) = 'DDK2025357850248043967'::text)
2.          

SubPlan (forIndex Scan)

3. 0.007 0.028 ↑ 1.0 1 1

Aggregate (cost=16.30..16.31 rows=1 width=32) (actual time=0.028..0.028 rows=1 loops=1)

4. 0.007 0.021 ↑ 1.0 3 1

Bitmap Heap Scan on mem_accounts2delegates (cost=4.45..16.29 rows=3 width=65) (actual time=0.018..0.021 rows=3 loops=1)

  • Recheck Cond: (("accountId")::text = (a.address)::text)
  • Heap Blocks: exact=3
5. 0.014 0.014 ↑ 1.0 3 1

Bitmap Index Scan on "mem_accounts2delegates_accountId" (cost=0.00..4.45 rows=3 width=0) (actual time=0.014..0.014 rows=3 loops=1)

  • Index Cond: (("accountId")::text = (a.address)::text)
6. 0.005 0.017 ↑ 1.0 1 1

Aggregate (cost=16.48..16.49 rows=1 width=32) (actual time=0.017..0.017 rows=1 loops=1)

7. 0.012 0.012 ↑ 1.0 3 1

Index Scan using "mem_accounts2u_delegates_accountId" on mem_accounts2u_delegates (cost=0.42..16.47 rows=3 width=65) (actual time=0.009..0.012 rows=3 loops=1)

  • Index Cond: (("accountId")::text = (a.address)::text)
8. 0.003 0.005 ↑ 1.0 1 1

Aggregate (cost=9.51..9.52 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=1)

9. 0.001 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on mem_accounts2multisignatures (cost=4.16..9.50 rows=2 width=146) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (("accountId")::text = (a.address)::text)
10. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on "mem_accounts2multisignatures_accountId" (cost=0.00..4.16 rows=2 width=0) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (("accountId")::text = (a.address)::text)
11. 0.001 0.004 ↑ 1.0 1 1

Aggregate (cost=9.51..9.52 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=1)

12. 0.001 0.003 ↓ 0.0 0 1

Bitmap Heap Scan on mem_accounts2u_multisignatures (cost=4.16..9.50 rows=2 width=146) (actual time=0.003..0.003 rows=0 loops=1)

  • Recheck Cond: (("accountId")::text = (a.address)::text)
13. 0.002 0.002 ↓ 0.0 0 1

Bitmap Index Scan on "mem_accounts2u_multisignatures_accountId" (cost=0.00..4.16 rows=2 width=0) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (("accountId")::text = (a.address)::text)