explain.depesz.com

PostgreSQL's explain analyze made readable

Result: emQK : Optimization for: plan #ojmZ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.123 141.201 ↑ 1.3 33 1

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

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

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

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

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

  • Hash Cond: ((so.id)::text = (t.id)::text)
4. 78.869 78.869 ↑ 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.022..78.869 rows=509,783 loops=1)

5. 0.049 0.845 ↑ 1.3 33 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
6. 0.016 0.796 ↑ 1.3 33 1

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

7. 0.014 0.780 ↑ 1.3 33 1

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

8. 0.028 0.766 ↑ 1.3 33 1

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

9. 0.023 0.738 ↑ 1.3 33 1

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

10. 0.031 0.715 ↑ 1.3 33 1

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

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

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

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

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

13. 0.062 0.062 ↑ 1.0 33 1

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

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

Hash Right Join (cost=56.58..74.29 rows=13 width=490) (actual time=0.013..0.013 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.330 ↓ 0.0 0 33

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
17. 0.297 0.297 ↓ 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.009..0.009 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.001 0.008 ↓ 0.0 0 1

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

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

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