explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RaN3

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 177.651 ↑ 1.3 6 1

Limit (cost=40,299.78..40,299.80 rows=8 width=1,715) (actual time=177.649..177.651 rows=6 loops=1)

2. 0.021 177.649 ↑ 4.7 6 1

Sort (cost=40,299.78..40,299.85 rows=28 width=1,715) (actual time=177.648..177.649 rows=6 loops=1)

  • Sort Key: t."timestamp" DESC
  • Sort Method: quicksort Memory: 33kB
3. 0.065 177.628 ↑ 4.7 6 1

WindowAgg (cost=121.68..40,299.22 rows=28 width=1,715) (actual time=177.624..177.628 rows=6 loops=1)

4. 0.011 177.563 ↑ 4.7 6 1

Nested Loop Left Join (cost=121.68..40,298.59 rows=28 width=1,774) (actual time=52.131..177.563 rows=6 loops=1)

5. 0.013 177.510 ↑ 4.7 6 1

Nested Loop Left Join (cost=121.26..40,062.06 rows=28 width=1,451) (actual time=52.121..177.510 rows=6 loops=1)

6. 0.035 177.461 ↑ 4.7 6 1

Nested Loop Left Join (cost=120.71..39,821.96 rows=28 width=1,215) (actual time=52.108..177.461 rows=6 loops=1)

7. 61.527 177.360 ↑ 4.7 6 1

Hash Right Join (cost=120.29..39,585.36 rows=28 width=1,211) (actual time=52.081..177.360 rows=6 loops=1)

  • Hash Cond: (v."transactionId" = t.id)
8. 115.742 115.742 ↑ 1.0 472,139 1

Seq Scan on votes v (cost=0.00..37,694.17 rows=472,217 width=523) (actual time=0.041..115.742 rows=472,139 loops=1)

9. 0.018 0.091 ↑ 4.7 6 1

Hash (cost=119.94..119.94 rows=28 width=753) (actual time=0.090..0.091 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
10. 0.026 0.073 ↑ 4.7 6 1

Bitmap Heap Scan on trs t (cost=9.08..119.94 rows=28 width=753) (actual time=0.056..0.073 rows=6 loops=1)

  • Recheck Cond: ((("recipientId")::text = 'DDK2131491563291774976'::text) OR ("senderPublicKey" = '\x64383432386338303530663239636261663466666265326263643461336466656334353735383738336437393365343066653231353265386537653366376334'::bytea))
  • Heap Blocks: exact=6
11. 0.000 0.047 ↓ 0.0 0 1

BitmapOr (cost=9.08..9.08 rows=28 width=0) (actual time=0.047..0.047 rows=0 loops=1)

12. 0.037 0.037 ↑ 1.0 6 1

Bitmap Index Scan on trs_upper_recipient_id (cost=0.00..4.47 rows=6 width=0) (actual time=0.037..0.037 rows=6 loops=1)

  • Index Cond: (("recipientId")::text = 'DDK2131491563291774976'::text)
13. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on "trs_senderPublicKey" (cost=0.00..4.59 rows=22 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ("senderPublicKey" = '\x64383432386338303530663239636261663466666265326263643461336466656334353735383738336437393365343066653231353265386537653366376334'::bytea)
14. 0.066 0.066 ↑ 1.0 1 6

Index Scan using blocks_pkey on blocks b (cost=0.42..8.44 rows=1 width=69) (actual time=0.010..0.011 rows=1 loops=6)

  • Index Cond: (t."blockId" = id)
15. 0.036 0.036 ↓ 0.0 0 6

Index Scan using stake_orders_pkey on stake_orders so (cost=0.55..8.56 rows=1 width=236) (actual time=0.006..0.006 rows=0 loops=6)

  • Index Cond: (id = t.id)
16. 0.042 0.042 ↑ 1.0 1 6

Index Scan using referals_pkey on referals ref (cost=0.42..8.44 rows=1 width=346) (actual time=0.007..0.007 rows=1 loops=6)

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