explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N2GG : Optimization for: Optimization for: plan #GBP; plan #8SYe

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 56.648 260.692 ↓ 4.0 21,705 1

Unique (cost=0.42..40,123.40 rows=5,390 width=23) (actual time=0.047..260.692 rows=21,705 loops=1)

2. 204.044 204.044 ↑ 1.0 652,228 1

Index Only Scan using main_order_transition_string on main_order (cost=0.42..38,492.83 rows=652,228 width=23) (actual time=0.045..204.044 rows=652,228 loops=1)

  • Heap Fetches: 188206
Planning time : 0.142 ms
Execution time : 261.584 ms