explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5WQq

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 173.742 ↑ 1.3 6 1

Limit (cost=40,269.34..40,269.36 rows=8 width=1,716) (actual time=173.737..173.742 rows=6 loops=1)

2. 0.017 173.741 ↑ 4.5 6 1

Sort (cost=40,269.34..40,269.41 rows=27 width=1,716) (actual time=173.736..173.741 rows=6 loops=1)

  • Sort Key: t."timestamp" DESC
  • Sort Method: quicksort Memory: 33kB
3. 0.036 173.724 ↑ 4.5 6 1

WindowAgg (cost=117.73..40,268.80 rows=27 width=1,716) (actual time=173.719..173.724 rows=6 loops=1)

4. 0.005 173.688 ↑ 4.5 6 1

Nested Loop Left Join (cost=117.73..40,268.20 rows=27 width=1,775) (actual time=31.333..173.688 rows=6 loops=1)

5. 0.011 173.659 ↑ 4.5 6 1

Nested Loop Left Join (cost=117.31..40,040.11 rows=27 width=1,451) (actual time=31.327..173.659 rows=6 loops=1)

6. 0.020 173.624 ↑ 4.5 6 1

Nested Loop Left Join (cost=116.76..39,808.59 rows=27 width=1,215) (actual time=31.318..173.624 rows=6 loops=1)

7. 58.159 173.562 ↑ 4.5 6 1

Hash Right Join (cost=116.34..39,580.44 rows=27 width=1,211) (actual time=31.301..173.562 rows=6 loops=1)

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

Seq Scan on votes v (cost=0.00..37,693.47 rows=472,147 width=523) (actual time=0.031..115.369 rows=472,139 loops=1)

9. 0.006 0.034 ↑ 4.5 6 1

Hash (cost=116.00..116.00 rows=27 width=753) (actual time=0.034..0.034 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
10. 0.010 0.028 ↑ 4.5 6 1

Bitmap Heap Scan on trs t (cost=9.07..116.00 rows=27 width=753) (actual time=0.023..0.028 rows=6 loops=1)

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

BitmapOr (cost=9.07..9.07 rows=27 width=0) (actual time=0.018..0.018 rows=0 loops=1)

12. 0.014 0.014 ↓ 1.2 6 1

Bitmap Index Scan on trs_upper_recipient_id (cost=0.00..4.46 rows=5 width=0) (actual time=0.014..0.014 rows=6 loops=1)

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

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

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

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

  • Index Cond: (t."blockId" = id)
15. 0.024 0.024 ↓ 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.004..0.004 rows=0 loops=6)

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

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

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