explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ojmZ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.077 125.829 ↑ 1.3 33 1

Sort (cost=15,583.54..15,583.64 rows=43 width=1,847) (actual time=125.824..125.829 rows=33 loops=1)

  • Sort Key: b.height, t.type, t."timestamp", t.id
  • Sort Method: quicksort Memory: 42kB
2. 0.124 125.752 ↑ 1.3 33 1

Hash Left Join (cost=728.54..15,582.37 rows=43 width=1,847) (actual time=125.701..125.752 rows=33 loops=1)

  • Hash Cond: ((t.id)::text = (ot."transactionId")::text)
3. 61.345 125.621 ↑ 1.3 33 1

Hash Right Join (cost=709.54..15,560.24 rows=43 width=1,834) (actual time=125.608..125.621 rows=33 loops=1)

  • Hash Cond: ((so.id)::text = (t.id)::text)
4. 63.649 63.649 ↑ 1.0 509,783 1

Seq Scan on stake_orders so (cost=0.00..12,938.83 rows=509,783 width=122) (actual time=0.009..63.649 rows=509,783 loops=1)

5. 0.046 0.627 ↑ 1.3 33 1

Hash (cost=709.00..709.00 rows=43 width=1,712) (actual time=0.627..0.627 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
6. 0.017 0.581 ↑ 1.3 33 1

Nested Loop Left Join (cost=658.59..709.00 rows=43 width=1,712) (actual time=0.500..0.581 rows=33 loops=1)

7. 0.012 0.564 ↑ 1.3 33 1

Nested Loop Left Join (cost=658.45..701.69 rows=43 width=882) (actual time=0.499..0.564 rows=33 loops=1)

8. 0.016 0.552 ↑ 1.3 33 1

Nested Loop Left Join (cost=658.30..691.69 rows=43 width=842) (actual time=0.498..0.552 rows=33 loops=1)

9. 0.017 0.536 ↑ 1.3 33 1

Nested Loop Left Join (cost=658.02..678.57 rows=43 width=809) (actual time=0.497..0.536 rows=33 loops=1)

10. 0.017 0.519 ↑ 1.3 33 1

Merge Left Join (cost=657.60..657.84 rows=43 width=743) (actual time=0.494..0.519 rows=33 loops=1)

  • Merge Cond: ((t.id)::text = (d."transactionId")::text)
11. 0.073 0.502 ↑ 1.3 33 1

Sort (cost=656.55..656.66 rows=43 width=685) (actual time=0.493..0.502 rows=33 loops=1)

  • Sort Key: t.id
  • Sort Method: quicksort Memory: 33kB
12. 0.042 0.429 ↑ 1.3 33 1

Nested Loop Left Join (cost=57.00..655.38 rows=43 width=685) (actual time=0.056..0.429 rows=33 loops=1)

13. 0.057 0.057 ↑ 1.0 33 1

Index Scan using blocks_height on blocks b (cost=0.42..10.09 rows=33 width=215) (actual time=0.011..0.057 rows=33 loops=1)

  • Index Cond: ((height > 39900) AND (height < 39934))
14. 0.066 0.330 ↓ 0.0 0 33

Hash Right Join (cost=56.58..74.29 rows=13 width=490) (actual time=0.010..0.010 rows=0 loops=33)

  • Hash Cond: ((it."transactionId")::text = (t.id)::text)
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on intransfer it (cost=0.00..15.60 rows=560 width=116) (never executed)

16. 0.033 0.264 ↓ 0.0 0 33

Hash (cost=56.41..56.41 rows=13 width=432) (actual time=0.008..0.008 rows=0 loops=33)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
17. 0.231 0.231 ↓ 0.0 0 33

Index Scan using trs_block_id on trs t (cost=0.43..56.41 rows=13 width=432) (actual time=0.007..0.007 rows=0 loops=33)

  • Index Cond: (("blockId")::text = (b.id)::text)
18. 0.000 0.000 ↓ 0.0 0

Sort (cost=1.05..1.06 rows=3 width=116) (never executed)

  • Sort Key: d."transactionId
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on delegates d (cost=0.00..1.03 rows=3 width=116) (never executed)

20. 0.000 0.000 ↓ 0.0 0 33

Index Scan using votes_trs_id on votes v (cost=0.42..0.47 rows=1 width=86) (actual time=0.000..0.000 rows=0 loops=33)

  • Index Cond: (("transactionId")::text = (t.id)::text)
21. 0.000 0.000 ↓ 0.0 0 33

Index Scan using signatures_trs_id on signatures s (cost=0.28..0.30 rows=1 width=53) (actual time=0.000..0.000 rows=0 loops=33)

  • Index Cond: (("transactionId")::text = (t.id)::text)
22. 0.000 0.000 ↓ 0.0 0 33

Index Scan using multisignatures_trs_id on multisignatures m (cost=0.15..0.20 rows=3 width=98) (actual time=0.000..0.000 rows=0 loops=33)

  • Index Cond: (("transactionId")::text = (t.id)::text)
23. 0.000 0.000 ↓ 0.0 0 33

Index Scan using dapps_trs_id on dapps dapp (cost=0.14..0.16 rows=1 width=888) (actual time=0.000..0.000 rows=0 loops=33)

  • Index Cond: (("transactionId")::text = (t.id)::text)
24. 0.002 0.007 ↓ 0.0 0 1

Hash (cost=14.00..14.00 rows=400 width=174) (actual time=0.007..0.007 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
25. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on outtransfer ot (cost=0.00..14.00 rows=400 width=174) (actual time=0.005..0.005 rows=0 loops=1)