explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yFzZ

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

Limit (cost=2.36..327.33 rows=8 width=1,707) (actual time=337.525..1,376.449 rows=8 loops=1)

2. 0.043 1,376.443 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=2.36..334,348.05 rows=8,231 width=1,707) (actual time=337.524..1,376.443 rows=8 loops=1)

3. 0.013 1,375.600 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=1.94..301,406.37 rows=8,231 width=1,451) (actual time=337.246..1,375.600 rows=8 loops=1)

4. 0.015 1,375.387 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=1.40..251,625.54 rows=8,231 width=1,215) (actual time=337.223..1,375.387 rows=8 loops=1)

5. 0.038 1,375.236 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=0.85..198,768.72 rows=8,231 width=757) (actual time=337.195..1,375.236 rows=8 loops=1)

6. 1,374.854 1,374.854 ↑ 1,028.9 8 1

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

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

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

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

  • Index Cond: ("transactionId" = t.id)
9. 0.200 0.200 ↓ 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.025..0.025 rows=0 loops=8)

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

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

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