explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3LRe

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Append (cost=75,061.93..77,862.49 rows=88,578 width=64) (never executed)

2.          

CTE inputs_cte

3. 0.000 0.000 ↓ 0.0

Append (cost=0.82..27,646.17 rows=32,871 width=291) (never executed)

4. 0.000 0.000 ↓ 0.0

Index Scan using inputs_0_pkey on inputs_0 inputs_0 (cost=0.82..18,572.53 rows=24,664 width=291) (never executed)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
5. 0.000 0.000 ↓ 0.0

Index Scan using inputs_1_pkey on inputs_1 inputs_1 (cost=0.82..8,905.06 rows=8,205 width=291) (never executed)

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

Index Scan using inputs_2_pkey on inputs_2 inputs_2 (cost=0.14..2.36 rows=1 width=291) (never executed)

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

Index Scan using inputs_default_pkey on inputs_default inputs_default (cost=0.27..1.87 rows=1 width=291) (never executed)

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

CTE outputs_cte

9. 0.000 0.000 ↓ 0.0

Append (cost=0.82..34,088.44 rows=40,062 width=213) (never executed)

10. 0.000 0.000 ↓ 0.0

Index Scan using outputs_0_pkey on outputs_0 outputs_0 (cost=0.82..20,357.26 rows=27,635 width=213) (never executed)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
11. 0.000 0.000 ↓ 0.0

Index Scan using outputs_1_pkey on outputs_1 outputs_1 (cost=0.82..13,526.16 rows=12,425 width=213) (never executed)

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

Index Scan using outputs_2_pkey on outputs_2 outputs_2 (cost=0.14..2.36 rows=1 width=213) (never executed)

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

Index Scan using outputs_default_pkey on outputs_default outputs_default (cost=0.14..2.36 rows=1 width=213) (never executed)

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

CTE transactions_cte

15. 0.000 0.000 ↓ 0.0

Append (cost=0.82..13,324.96 rows=15,644 width=152) (never executed)

16. 0.000 0.000 ↓ 0.0

Index Scan using transactions_0_pkey on transactions_0 transactions_0 (cost=0.82..7,390.07 rows=10,135 width=152) (never executed)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
17. 0.000 0.000 ↓ 0.0

Index Scan using transactions_1_pkey on transactions_1 transactions_1 (cost=0.69..5,851.95 rows=5,507 width=150) (never executed)

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

Index Scan using transactions_2_pkey on transactions_2 transactions_2 (cost=0.14..2.36 rows=1 width=842) (never executed)

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

Index Scan using transactions_default_pkey on transactions_default transactions_default (cost=0.14..2.36 rows=1 width=842) (never executed)

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

CTE omni_transfers_cte

21. 0.000 0.000 ↓ 0.0

Index Scan using block_hash_idx on omni omni (cost=0.14..2.36 rows=1 width=758) (never executed)

  • Index Cond: ((block_hash)::text = '0000000000000000013cd4805d375fc4bd95f86cb44d7051420158e65ed24281'::text)
22. 0.000 0.000 ↓ 0.0

CTE Scan on transactions_cte transactions_cte (cost=0.00..351.99 rows=15,644 width=64) (never executed)

23. 0.000 0.000 ↓ 0.0

CTE Scan on inputs_cte inputs_cte (cost=0.00..903.95 rows=32,871 width=64) (never executed)

24. 0.000 0.000 ↓ 0.0

CTE Scan on outputs_cte outputs_cte (cost=0.00..1,101.70 rows=40,062 width=64) (never executed)

25. 0.000 0.000 ↓ 0.0

CTE Scan on omni_transfers_cte omni_transfers_cte (cost=0.00..0.03 rows=1 width=64) (never executed)