explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JmYv

Settings
# exclusive inclusive rows x rows loops node
1. 13,575.849 26,708.905 ↓ 1.3 616,227 1

Gather (cost=1,000.57..585,193.09 rows=489,132 width=16) (actual time=3.330..26,708.905 rows=616,227 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 13,133.056 13,133.056 ↓ 1.3 616,227 1 / 2

Index Scan using feed_line_step_id_index on feed_line (cost=0.57..535,279.89 rows=489,132 width=16) (actual time=0.024..26,266.112 rows=616,227 loops=1)

  • Index Cond: (step_id = '8deef7de-33cc-4a5e-9697-b68fc2bca2cb'::uuid)
Planning time : 0.130 ms
Execution time : 27,017.710 ms