explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ajKO

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.152 ↓ 0.0 0 1

Nested Loop (cost=2.76..37.54 rows=1 width=356) (actual time=0.151..0.152 rows=0 loops=1)

2. 0.000 0.150 ↓ 0.0 0 1

Nested Loop (cost=2.48..30.37 rows=1 width=245) (actual time=0.150..0.150 rows=0 loops=1)

3. 0.001 0.150 ↓ 0.0 0 1

Nested Loop (cost=2.20..26.66 rows=1 width=212) (actual time=0.150..0.150 rows=0 loops=1)

  • Join Filter: (recipient_asset.provider_id = recipient_asset_provider.id)
4. 0.003 0.149 ↓ 0.0 0 1

Nested Loop (cost=2.20..25.59 rows=1 width=216) (actual time=0.149..0.149 rows=0 loops=1)

  • Join Filter: (ab.recipient_asset_id = recipient_asset.id)
5. 0.032 0.032 ↑ 1.0 1 1

Seq Scan on assets recipient_asset (cost=0.00..1.10 rows=1 width=96) (actual time=0.028..0.032 rows=1 loops=1)

  • Filter: ((asset)::text = 'WAVES'::text)
  • Rows Removed by Filter: 7
6. 0.030 0.114 ↓ 0.0 0 1

Hash Join (cost=2.20..24.38 rows=9 width=128) (actual time=0.114..0.114 rows=0 loops=1)

  • Hash Cond: (tb.asset_binding_id = ab.id)
7. 0.010 0.010 ↑ 75.0 1 1

Seq Scan on transfer_bindings tb (cost=0.00..21.75 rows=75 width=16) (actual time=0.010..0.010 rows=1 loops=1)

8. 0.000 0.074 ↓ 0.0 0 1

Hash (cost=2.19..2.19 rows=1 width=120) (actual time=0.074..0.074 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.042 0.074 ↓ 0.0 0 1

Hash Join (cost=1.11..2.19 rows=1 width=120) (actual time=0.073..0.074 rows=0 loops=1)

  • Hash Cond: (ab.sender_asset_id = sender_asset.id)
10. 0.012 0.012 ↑ 1.2 4 1

Seq Scan on asset_bindings ab (cost=0.00..1.05 rows=5 width=36) (actual time=0.010..0.012 rows=4 loops=1)

11. 0.006 0.020 ↑ 1.0 1 1

Hash (cost=1.10..1.10 rows=1 width=92) (actual time=0.019..0.020 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.014 0.014 ↑ 1.0 1 1

Seq Scan on assets sender_asset (cost=0.00..1.10 rows=1 width=92) (actual time=0.009..0.014 rows=1 loops=1)

  • Filter: ((asset)::text = 'WAVES'::text)
  • Rows Removed by Filter: 7
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on providers recipient_asset_provider (cost=0.00..1.03 rows=3 width=4) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Index Scan using addresses_pkey on addresses sender (cost=0.28..3.71 rows=1 width=41) (never executed)

  • Index Cond: (id = tb.sender_address_id)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using addresses_pkey on addresses recipient (cost=0.28..3.71 rows=1 width=41) (never executed)

  • Index Cond: (id = tb.recipient_address_id)
  • Filter: ((address)::text = '121'::text)
Planning time : 3.274 ms
Execution time : 0.439 ms