explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GK8H

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=328,260.90..328,260.92 rows=8 width=1,708) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=328,260.90..328,281.47 rows=8,230 width=1,708) (actual rows= loops=)

  • Sort Key: t."timestamp" DESC
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=216,209.36..328,096.30 rows=8,230 width=1,708) (actual rows= loops=)

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

Hash Right Join (cost=192,316.83..296,786.31 rows=8,230 width=1,771) (actual rows= loops=)

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

Seq Scan on votes v (cost=0.00..37,694.07 rows=472,207 width=524) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=190,870.96..190,870.96 rows=8,230 width=1,312) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=135,666.00..190,870.96 rows=8,230 width=1,312) (actual rows= loops=)

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

Seq Scan on stake_orders so (cost=0.00..19,537.00 rows=506,300 width=236) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=134,453.13..134,453.13 rows=8,230 width=1,076) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=113,510.71..134,453.13 rows=8,230 width=1,076) (actual rows= loops=)

  • Merge Cond: ((ref.address)::text = (t."senderId")::text)
11. 0.000 0.000 ↓ 0.0

Index Scan using referals_pkey on referals ref (cost=0.42..20,183.97 rows=245,936 width=346) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Materialize (cost=113,510.29..113,551.44 rows=8,230 width=753) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Sort (cost=113,510.29..113,530.87 rows=8,230 width=753) (actual rows= loops=)

  • Sort Key: t."senderId
14. 0.000 0.000 ↓ 0.0

Seq Scan on trs t (cost=0.00..110,217.07 rows=8,230 width=753) (actual rows= loops=)

  • Filter: ((("recipientId")::text = 'DDK9653090373578057426'::text) OR (encode("senderPublicKey", 'hex'::text) = '5374d88bdf6ffd617e25235f5e27f4c0d3f348f96febfd4c7184097569c2f1f8'::text))
15. 0.000 0.000 ↓ 0.0

Hash (cost=16,444.90..16,444.90 rows=307,490 width=69) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on blocks b (cost=0.00..16,444.90 rows=307,490 width=69) (actual rows= loops=)