explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SN2Q : example33

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.029 ↑ 1.0 1 1

GroupAggregate (cost=12.62..12.64 rows=1 width=12) (actual time=0.029..0.029 rows=1 loops=1)

2. 0.026 0.026 ↑ 1.0 1 1

Sort (cost=12.62..12.62 rows=1 width=8) (actual time=0.025..0.026 rows=1 loops=1)

3. 0.017 0.017 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.56..12.61 rows=1 width=8) (actual time=0.015..0.017 rows=1 loops=1)

4. 0.010 0.010 ↑ 1.0 1 1

Index Only Scan using line_items_created_at_order_id_price on line_items (cost=0.27..4.29 rows=1 width=8) (actual time=0.009..0.010 rows=1 loops=1)

5. 0.005 0.005 ↑ 1.0 1 1

Index Scan using orders_pkey on orders (cost=0.29..8.30 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)