explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xx8T

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 77.308 ↑ 1.0 1 1

Nested Loop (cost=1,000.42..15,562.89 rows=1 width=49) (actual time=0.406..77.308 rows=1 loops=1)

2. 0.027 0.027 ↑ 1.0 1 1

Index Scan using orders_pkey on orders a (cost=0.42..8.44 rows=1 width=8) (actual time=0.010..0.027 rows=1 loops=1)

  • Index Cond: (order_id = 5)
3. 20.204 77.278 ↑ 1.0 1 1

Gather (cost=1,000.00..15,554.43 rows=1 width=41) (actual time=0.393..77.278 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 57.074 57.074 ↓ 0.0 0 3 / 3

Parallel Seq Scan on order_lines b (cost=0.00..14,554.33 rows=1 width=41) (actual time=31.877..57.074 rows=0 loops=3)

  • Filter: (order_id = 5)
  • Rows Removed by Filter: 333,333
Planning time : 1.031 ms
Execution time : 77.377 ms