explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fln0

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 1,803.487 ↑ 1.0 8 1

Limit (cost=1.82..191,590.79 rows=8 width=1,709) (actual time=470.493..1,803.487 rows=8 loops=1)

2. 0.064 1,803.479 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=1.82..197,121,107.20 rows=8,231 width=1,709) (actual time=470.490..1,803.479 rows=8 loops=1)

3. 278.017 1,803.239 ↑ 1,028.9 8 1

Nested Loop Left Join (cost=1.40..197,088,165.52 rows=8,231 width=1,451) (actual time=470.459..1,803.239 rows=8 loops=1)

  • Join Filter: (so.id = t.id)
  • Rows Removed by Join Filter: 4050398
4. 0.011 748.398 ↑ 1,028.9 8 1

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

5. 0.039 748.251 ↑ 1,028.9 8 1

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

6. 748.068 748.068 ↑ 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=154.291..748.068 rows=8 loops=1)

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

Index Scan using blocks_pkey on blocks b (cost=0.42..5.24 rows=1 width=69) (actual time=0.018..0.018 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.016..0.017 rows=0 loops=8)

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

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

10. 105.411 105.411 ↑ 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.008..105.411 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)