explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hyrk

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 0.082 ↑ 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.081..0.082 rows=1 loops=1)

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

SubPlan (forIndex Scan)

3. 0.012 0.033 ↑ 1.0 1 1

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

4. 0.012 0.021 ↑ 1.0 3 1

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

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

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

  • Index Cond: (("accountId")::text = (a.address)::text)
6. 0.008 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.009 0.009 ↑ 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.007..0.009 rows=3 loops=1)

  • Index Cond: (("accountId")::text = (a.address)::text)
8. 0.002 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)

9. 0.000 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.002 0.002 ↓ 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.002 rows=0 loops=1)

  • Index Cond: (("accountId")::text = (a.address)::text)
11. 0.002 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.000 0.002 ↓ 0.0 0 1

Bitmap Heap Scan on mem_accounts2u_multisignatures (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)
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)