explain.depesz.com

PostgreSQL's explain analyze made readable

Result: frG

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

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

2. 0.017 0.219 ↑ 4.7 6 1

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

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

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

4. 0.005 0.174 ↑ 4.7 6 1

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

5. 0.002 0.145 ↑ 4.7 6 1

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

6. 0.008 0.113 ↑ 4.7 6 1

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

7. 0.007 0.075 ↑ 4.7 6 1

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

8. 0.008 0.032 ↑ 4.7 6 1

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

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

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

10. 0.016 0.016 ↑ 1.0 6 1

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

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

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

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

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

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

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

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

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

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