explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f9vi

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

Limit (cost=1,074.46..1,074.48 rows=8 width=1,717) (actual time=0.161..0.164 rows=6 loops=1)

2. 0.014 0.163 ↑ 4.7 6 1

Sort (cost=1,074.46..1,074.53 rows=28 width=1,717) (actual time=0.160..0.163 rows=6 loops=1)

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

WindowAgg (cost=11.02..1,073.90 rows=28 width=1,717) (actual time=0.145..0.149 rows=6 loops=1)

4. 0.003 0.131 ↑ 4.7 6 1

Nested Loop Left Join (cost=11.02..1,073.27 rows=28 width=1,776) (actual time=0.048..0.131 rows=6 loops=1)

5. 0.001 0.110 ↑ 4.7 6 1

Nested Loop Left Join (cost=10.60..836.74 rows=28 width=1,451) (actual time=0.043..0.110 rows=6 loops=1)

6. 0.003 0.085 ↑ 4.7 6 1

Nested Loop Left Join (cost=10.05..596.64 rows=28 width=1,215) (actual time=0.037..0.085 rows=6 loops=1)

7. 0.007 0.058 ↑ 4.7 6 1

Nested Loop Left Join (cost=9.50..356.54 rows=28 width=757) (actual time=0.031..0.058 rows=6 loops=1)

8. 0.008 0.027 ↑ 4.7 6 1

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

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

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

10. 0.014 0.014 ↑ 1.0 6 1

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

  • Index Cond: (("recipientId")::text = 'DDK2131491563291774976'::text)
11. 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)
12. 0.024 0.024 ↑ 1.0 1 6

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

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

Index Scan using votes_transactionid_pk on votes v (cost=0.55..8.56 rows=1 width=523) (actual time=0.004..0.004 rows=0 loops=6)

  • Index Cond: ("transactionId" = t.id)
14. 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)
15. 0.018 0.018 ↑ 1.0 1 6

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

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