explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jATby

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

Aggregate (cost=588,538.48..588,538.49 rows=1 width=8) (actual time=1,740.216..1,740.217 rows=1 loops=1)

2. 126.279 1,853.943 ↑ 1.0 1 1

Gather (cost=1,000.00..588,538.47 rows=1 width=0) (actual time=1,740.139..1,853.943 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,727.664 1,727.664 ↓ 0.0 0 3 / 3

Parallel Seq Scan on account accountmod0_ (cost=0.00..587,538.38 rows=1 width=0) (actual time=1,727.664..1,727.664 rows=0 loops=3)

  • Filter: (id = '38765200'::bigint)
  • Rows Removed by Filter: 12,921,648
Planning time : 0.131 ms
Execution time : 1,854.015 ms