explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Hnm

Settings
# exclusive inclusive rows x rows loops node
1. 12.009 830.800 ↓ 1.2 102,536 1

Append (cost=75,061.93..77,862.49 rows=88,578 width=64) (actual time=0.064..830.800 rows=102,536 loops=1)

2.          

CTE inputs_cte

3. 5.155 47.174 ↓ 1.2 40,831 1

Append (cost=0.82..27,646.17 rows=32,871 width=291) (actual time=0.051..47.174 rows=40,831 loops=1)

4. 0.027 0.027 ↓ 0.0 0 1

Index Scan using inputs_0_pkey on inputs_0 (cost=0.82..18,572.53 rows=24,664 width=291) (actual time=0.027..0.027 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
5. 41.974 41.974 ↓ 5.0 40,831 1

Index Scan using inputs_1_pkey on inputs_1 (cost=0.82..8,905.06 rows=8,205 width=291) (actual time=0.023..41.974 rows=40,831 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
6. 0.008 0.008 ↓ 0.0 0 1

Index Scan using inputs_2_pkey on inputs_2 (cost=0.14..2.36 rows=1 width=291) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
7. 0.010 0.010 ↓ 0.0 0 1

Index Scan using inputs_default_pkey on inputs_default (cost=0.27..1.87 rows=1 width=291) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
8.          

CTE outputs_cte

9. 4.874 46.114 ↓ 1.1 43,081 1

Append (cost=0.82..34,088.44 rows=40,062 width=213) (actual time=0.054..46.114 rows=43,081 loops=1)

10. 0.025 0.025 ↓ 0.0 0 1

Index Scan using outputs_0_pkey on outputs_0 (cost=0.82..20,357.26 rows=27,635 width=213) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
11. 41.199 41.199 ↓ 3.5 43,081 1

Index Scan using outputs_1_pkey on outputs_1 (cost=0.82..13,526.16 rows=12,425 width=213) (actual time=0.029..41.199 rows=43,081 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
12. 0.008 0.008 ↓ 0.0 0 1

Index Scan using outputs_2_pkey on outputs_2 (cost=0.14..2.36 rows=1 width=213) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
13. 0.008 0.008 ↓ 0.0 0 1

Index Scan using outputs_default_pkey on outputs_default (cost=0.14..2.36 rows=1 width=213) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
14.          

CTE transactions_cte

15. 2.229 21.478 ↓ 1.2 18,624 1

Append (cost=0.82..13,324.96 rows=15,644 width=152) (actual time=0.052..21.478 rows=18,624 loops=1)

16. 0.029 0.029 ↓ 0.0 0 1

Index Scan using transactions_0_pkey on transactions_0 (cost=0.82..7,390.07 rows=10,135 width=152) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
17. 19.203 19.203 ↓ 3.4 18,624 1

Index Scan using transactions_1_pkey on transactions_1 (cost=0.69..5,851.95 rows=5,507 width=150) (actual time=0.023..19.203 rows=18,624 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
18. 0.008 0.008 ↓ 0.0 0 1

Index Scan using transactions_2_pkey on transactions_2 (cost=0.14..2.36 rows=1 width=842) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
19. 0.009 0.009 ↓ 0.0 0 1

Index Scan using transactions_default_pkey on transactions_default (cost=0.14..2.36 rows=1 width=842) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
20.          

CTE omni_transfers_cte

21. 0.003 0.003 ↓ 0.0 0 1

Index Scan using block_hash_idx on omni (cost=0.14..2.36 rows=1 width=758) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
22. 111.971 111.971 ↓ 1.2 18,624 1

CTE Scan on transactions_cte (cost=0.00..351.99 rows=15,644 width=64) (actual time=0.064..111.971 rows=18,624 loops=1)

23. 417.037 417.037 ↓ 1.2 40,831 1

CTE Scan on inputs_cte (cost=0.00..903.95 rows=32,871 width=64) (actual time=0.064..417.037 rows=40,831 loops=1)

24. 289.779 289.779 ↓ 1.1 43,081 1

CTE Scan on outputs_cte (cost=0.00..1,101.70 rows=40,062 width=64) (actual time=0.075..289.779 rows=43,081 loops=1)

25. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on omni_transfers_cte (cost=0.00..0.03 rows=1 width=64) (actual time=0.004..0.004 rows=0 loops=1)

Planning time : 0.835 ms
Execution time : 842.917 ms