explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OQEg

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 790.614 ↑ 1.0 8 1

Limit (cost=2.36..327.50 rows=8 width=1,709) (actual time=172.171..790.614 rows=8 loops=1)

2. 0.025 790.608 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=2.36..334,528.77 rows=8,231 width=1,709) (actual time=172.170..790.608 rows=8 loops=1)

3. 0.011 790.479 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=1.94..301,587.09 rows=8,231 width=1,451) (actual time=172.149..790.479 rows=8 loops=1)

4. 0.016 790.348 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=1.40..251,806.27 rows=8,231 width=1,215) (actual time=172.129..790.348 rows=8 loops=1)

5. 0.034 790.220 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=0.85..198,949.44 rows=8,231 width=757) (actual time=172.109..790.220 rows=8 loops=1)

6. 790.058 790.058 ↑ 1,028.9 8 1

Index Scan Backward using trs_timestamp on trs t (cost=0.43..155,713.49 rows=8,231 width=753) (actual time=172.080..790.058 rows=8 loops=1)

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

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

  • Index Cond: (t."blockId" = id)
8. 0.112 0.112 ↓ 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.014..0.014 rows=0 loops=8)

  • Index Cond: ("transactionId" = t.id)
9. 0.120 0.120 ↓ 0.0 0 8

Index Scan using stake_orders_pkey on stake_orders so (cost=0.55..6.04 rows=1 width=236) (actual time=0.015..0.015 rows=0 loops=8)

  • Index Cond: (id = t.id)
10. 0.104 0.104 ↑ 1.0 1 8

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

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