explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 531

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 11.896 ↑ 1.3 6 1

Limit (cost=1,074.46..1,074.48 rows=8 width=1,715) (actual time=11.894..11.896 rows=6 loops=1)

2. 0.016 11.893 ↑ 4.7 6 1

Sort (cost=1,074.46..1,074.53 rows=28 width=1,715) (actual time=11.892..11.893 rows=6 loops=1)

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

WindowAgg (cost=11.02..1,073.90 rows=28 width=1,715) (actual time=11.872..11.877 rows=6 loops=1)

4. 0.006 11.845 ↑ 4.7 6 1

Nested Loop Left Join (cost=11.02..1,073.27 rows=28 width=1,774) (actual time=2.840..11.845 rows=6 loops=1)

5. 0.009 10.303 ↑ 4.7 6 1

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

6. 0.010 8.044 ↑ 4.7 6 1

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

7. 0.011 5.058 ↑ 4.7 6 1

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

8. 0.240 1.399 ↑ 4.7 6 1

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

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

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

10. 0.544 0.544 ↑ 1.0 6 1

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

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

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

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

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

  • Index Cond: (t."blockId" = id)
13. 2.976 2.976 ↓ 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.496..0.496 rows=0 loops=6)

  • Index Cond: ("transactionId" = t.id)
14. 2.250 2.250 ↓ 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.375..0.375 rows=0 loops=6)

  • Index Cond: (id = t.id)
15. 1.536 1.536 ↑ 1.0 1 6

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

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