explain.depesz.com

PostgreSQL's explain analyze made readable

Result: claq

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

Limit (cost=2.36..21.35 rows=8 width=1,718) (actual time=59,318.269..59,318.661 rows=8 loops=1)

2. 3,587.071 59,318.655 ↑ 205,615.8 8 1

WindowAgg (cost=2.36..3,903,357.26 rows=1,644,926 width=1,718) (actual time=59,318.268..59,318.655 rows=8 loops=1)

3. 866.434 55,731.584 ↑ 1.0 1,644,926 1

Nested Loop Left Join (cost=2.36..3,866,346.42 rows=1,644,926 width=1,777) (actual time=2.013..55,731.584 rows=1,644,926 loops=1)

4. 461.732 44,995.594 ↑ 1.0 1,644,926 1

Nested Loop Left Join (cost=1.94..3,079,062.04 rows=1,644,926 width=1,451) (actual time=1.781..44,995.594 rows=1,644,926 loops=1)

5. 803.713 33,019.380 ↑ 1.0 1,644,926 1

Nested Loop Left Join (cost=1.40..2,051,693.59 rows=1,644,926 width=1,215) (actual time=1.355..33,019.380 rows=1,644,926 loops=1)

6. 499.417 19,056.259 ↑ 1.0 1,644,926 1

Nested Loop Left Join (cost=0.85..951,929.14 rows=1,644,926 width=757) (actual time=1.086..19,056.259 rows=1,644,926 loops=1)

7. 10,332.212 10,332.212 ↑ 1.0 1,644,926 1

Index Scan Backward using trs_timestamp on trs t (cost=0.43..143,876.44 rows=1,644,926 width=753) (actual time=0.649..10,332.212 rows=1,644,926 loops=1)

8. 8,224.630 8,224.630 ↑ 1.0 1 1,644,926

Index Scan using blocks_pkey on blocks b (cost=0.42..0.48 rows=1 width=264) (actual time=0.005..0.005 rows=1 loops=1,644,926)

  • Index Cond: (t."blockId" = id)
9. 13,159.408 13,159.408 ↓ 0.0 0 1,644,926

Index Scan using votes_transactionid_pk on votes v (cost=0.55..0.66 rows=1 width=523) (actual time=0.008..0.008 rows=0 loops=1,644,926)

  • Index Cond: ("transactionId" = t.id)
10. 11,514.482 11,514.482 ↓ 0.0 0 1,644,926

Index Scan using stake_orders_pkey on stake_orders so (cost=0.55..0.61 rows=1 width=236) (actual time=0.007..0.007 rows=0 loops=1,644,926)

  • Index Cond: (id = t.id)
11. 9,869.556 9,869.556 ↑ 1.0 1 1,644,926

Index Scan using referals_pkey on referals ref (cost=0.42..0.47 rows=1 width=349) (actual time=0.006..0.006 rows=1 loops=1,644,926)

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