explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gx5S

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 0.053 ↓ 0.0 0 1

Sort (cost=401.88..401.96 rows=34 width=3,877) (actual time=0.053..0.053 rows=0 loops=1)

  • Sort Key: b.height, t.type, t."timestamp", t.id
  • Sort Method: quicksort Memory: 25kB
2. 0.001 0.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=108.42..401.01 rows=34 width=3,877) (actual time=0.032..0.032 rows=0 loops=1)

3. 0.006 0.031 ↓ 0.0 0 1

Hash Right Join (cost=108.00..119.64 rows=34 width=3,588) (actual time=0.031..0.031 rows=0 loops=1)

  • Hash Cond: (ot."transactionId" = t.id)
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on outtransfer ot (cost=0.00..11.00 rows=100 width=780) (never executed)

5. 0.000 0.025 ↓ 0.0 0 1

Hash (cost=107.57..107.57 rows=34 width=3,068) (actual time=0.025..0.025 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.004 0.025 ↓ 0.0 0 1

Hash Right Join (cost=95.03..107.57 rows=34 width=3,068) (actual time=0.025..0.025 rows=0 loops=1)

  • Hash Cond: (so.id = t.id)
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on stake_orders so (cost=0.00..11.60 rows=160 width=450) (never executed)

8. 0.000 0.021 ↓ 0.0 0 1

Hash (cost=94.61..94.61 rows=34 width=2,618) (actual time=0.021..0.021 rows=0 loops=1)

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

Hash Right Join (cost=81.25..94.61 rows=34 width=2,618) (actual time=0.021..0.022 rows=0 loops=1)

  • Hash Cond: (v."transactionId" = t.id)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on votes v (cost=0.00..12.20 rows=220 width=340) (never executed)

11. 0.000 0.017 ↓ 0.0 0 1

Hash (cost=80.88..80.88 rows=30 width=2,538) (actual time=0.017..0.017 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
12. 0.000 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=42.42..80.88 rows=30 width=2,538) (actual time=0.017..0.017 rows=0 loops=1)

13. 0.000 0.017 ↓ 0.0 0 1

Hash Left Join (cost=42.28..67.77 rows=25 width=2,498) (actual time=0.017..0.017 rows=0 loops=1)

  • Hash Cond: (t.id = dapp."transactionId")
14. 0.000 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=30.70..55.96 rows=25 width=1,668) (actual time=0.017..0.017 rows=0 loops=1)

15. 0.000 0.017 ↓ 0.0 0 1

Hash Left Join (cost=30.56..42.84 rows=25 width=1,636) (actual time=0.017..0.017 rows=0 loops=1)

  • Hash Cond: (t.id = d."transactionId")
16. 0.006 0.017 ↓ 0.0 0 1

Hash Right Join (cost=29.31..41.48 rows=25 width=1,578) (actual time=0.017..0.017 rows=0 loops=1)

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

Seq Scan on intransfer it (cost=0.00..11.40 rows=140 width=520) (never executed)

18. 0.000 0.011 ↓ 0.0 0 1

Hash (cost=29.00..29.00 rows=25 width=1,318) (actual time=0.011..0.011 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
19. 0.004 0.011 ↓ 0.0 0 1

Hash Right Join (cost=1.03..29.00 rows=25 width=1,318) (actual time=0.011..0.011 rows=0 loops=1)

  • Hash Cond: (t."blockId" = b.id)
20. 0.000 0.000 ↓ 0.0 0

Seq Scan on trs t (cost=0.00..27.25 rows=125 width=723) (never executed)

21. 0.001 0.007 ↓ 0.0 0 1

Hash (cost=1.01..1.01 rows=1 width=660) (actual time=0.007..0.007 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
22. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on blocks b (cost=0.00..1.01 rows=1 width=660) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((height > 39900) AND (height < 39934))
  • Rows Removed by Filter: 5
23. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.11..1.11 rows=11 width=318) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on delegates d (cost=0.00..1.11 rows=11 width=318) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Index Scan using signatures_trs_id on signatures s (cost=0.14..0.51 rows=1 width=292) (never executed)

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

Hash (cost=10.70..10.70 rows=70 width=1,090) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Seq Scan on dapps dapp (cost=0.00..10.70 rows=70 width=1,090) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Index Scan using multisignatures_trs_id on multisignatures m (cost=0.14..0.51 rows=1 width=300) (never executed)

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

Index Scan using referals_pkey on referals ref (cost=0.42..8.25 rows=1 width=346) (never executed)

  • Index Cond: ((address)::text = (t."senderId")::text)