explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pOxZ

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

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

2. 0.034 184.050 ↑ 4.5 6 1

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

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

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

4. 0.016 183.946 ↑ 4.5 6 1

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

5. 0.032 182.250 ↑ 4.5 6 1

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

6. 0.028 182.104 ↑ 4.5 6 1

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

7. 58.767 177.588 ↑ 4.5 6 1

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

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

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

9. 0.011 1.936 ↑ 4.5 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
10. 0.041 1.925 ↑ 4.5 6 1

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

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

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

12. 1.203 1.203 ↓ 1.2 6 1

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

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

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

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

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

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

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

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

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