explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jj1S

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 1,864.197 ↑ 1.0 8 1

Limit (cost=1.82..191,590.75 rows=8 width=1,709) (actual time=506.195..1,864.197 rows=8 loops=1)

2. 0.060 1,864.187 ↑ 1,029.1 8 1

Nested Loop Left Join (cost=1.82..197,168,958.14 rows=8,233 width=1,709) (actual time=506.192..1,864.187 rows=8 loops=1)

3. 282.429 1,863.951 ↑ 1,029.1 8 1

Nested Loop Left Join (cost=1.40..197,136,011.54 rows=8,233 width=1,451) (actual time=506.164..1,863.951 rows=8 loops=1)

  • Join Filter: (so.id = t.id)
  • Rows Removed by Join Filter: 4050398
4. 0.010 800.810 ↑ 1,029.1 8 1

Nested Loop Left Join (cost=1.40..251,829.29 rows=8,233 width=1,215) (actual time=194.071..800.810 rows=8 loops=1)

5. 0.040 800.672 ↑ 1,029.1 8 1

Nested Loop Left Join (cost=0.85..198,963.32 rows=8,233 width=757) (actual time=194.051..800.672 rows=8 loops=1)

6. 800.496 800.496 ↑ 1,029.1 8 1

Index Scan Backward using trs_timestamp on trs t (cost=0.43..155,722.47 rows=8,233 width=753) (actual time=194.023..800.496 rows=8 loops=1)

  • Filter: ((("recipientId")::text = 'DDK2131491563291774976'::text) OR (encode("senderPublicKey", 'hex'::text) = 'd8428c8050f29cbaf4ffbe2bcd4a3dfec45758783d793e40fe2152e8e7e3f7c4'::text))
  • Rows Removed by Filter: 1289370
7. 0.136 0.136 ↑ 1.0 1 8

Index Scan using blocks_pkey on blocks b (cost=0.42..5.24 rows=1 width=69) (actual time=0.017..0.017 rows=1 loops=8)

  • Index Cond: (t."blockId" = id)
8. 0.128 0.128 ↓ 0.0 0 8

Index Scan using votes_transactionid_pk on votes v (cost=0.55..6.41 rows=1 width=523) (actual time=0.015..0.016 rows=0 loops=8)

  • Index Cond: ("transactionId" = t.id)
9. 678.236 780.712 ↑ 1.0 506,300 8

Materialize (cost=0.00..38,385.50 rows=506,300 width=236) (actual time=0.007..97.589 rows=506,300 loops=8)

10. 102.476 102.476 ↑ 1.0 506,300 1

Seq Scan on stake_orders so (cost=0.00..19,537.00 rows=506,300 width=236) (actual time=0.007..102.476 rows=506,300 loops=1)

11. 0.176 0.176 ↑ 1.0 1 8

Index Scan using referals_pkey on referals ref (cost=0.42..3.98 rows=1 width=348) (actual time=0.022..0.022 rows=1 loops=8)

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