explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C3dkD

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

Limit (cost=119,449.90..119,450.50 rows=5 width=12) (actual time=1,752.504..1,752.514 rows=5 loops=1)

2. 209.888 1,783.089 ↑ 199,997.0 5 1

Gather Merge (cost=119,449.90..240,372.89 rows=999,985 width=12) (actual time=1,752.501..1,783.089 rows=5 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
3. 69.358 1,573.201 ↑ 39,999.4 5 6 / 6

Sort (cost=118,449.82..118,949.81 rows=199,997 width=12) (actual time=1,573.200..1,573.201 rows=5 loops=6)

  • Sort Key: (sqrt(power(('(1.47, -0.38, 0.34, 1.99, 1.1, -0.8, 0.93, 0.26, -1.68, -0.33, -1.27, 1.67, 0.71, -0.33, 0.46, -0.72, -0.95, 0.88, 0.37, -0.67, -1.35, -1.21, 0.41, -0.83, 0.21, -0.3, -1.89, -1.63, 1.62, -1.57, 0.56, -1.11, -1.24, 0.53, -0.49, -0.56, -0.82, 1.38, 1.58, 0.03, 0.96, -0.57, 1.99, -1.53, 1.41, 1.77, -1.75, -1.03, -0.66, -0.41, 1.49, 1.9, -1.36, -1.98, -0.49, 0.72, -0.56, -1.72, -0.16, 1.62, 0.41, 0.43, 1.87, -0.9, 1.61, 0, 0.13, 0.87, -1.77, 0.35, -0.92, -0.92, -0.57, 0.68, -0.58, 1.76, 1.08, -1.49, -0.55, -0.03, 0.41, -0.52, 1.28, -1.14, -0.23, -0.31, -1.82, -0.97, 0.45, 0.12, 1.69, 1.93, -0.36, -0.3, -0.01, -0.95, 0.37, -0.31, -1.74, -1.45)'::cube <-> vector1), '2'::double precision)))
  • Sort Method: top-N heapsort Memory: 25kB
  • Worker 0: Sort Method: top-N heapsort Memory: 25kB
  • Worker 1: Sort Method: top-N heapsort Memory: 25kB
  • Worker 2: Sort Method: top-N heapsort Memory: 25kB
  • Worker 3: Sort Method: top-N heapsort Memory: 25kB
  • Worker 4: Sort Method: top-N heapsort Memory: 25kB
4. 1,503.843 1,503.843 ↑ 1.2 166,667 6 / 6

Parallel Seq Scan on project_with_cube (cost=0.00..115,127.94 rows=199,997 width=12) (actual time=2.907..1,503.843 rows=166,667 loops=6)

  • Filter: (project_id = 1)
Planning time : 0.380 ms
Execution time : 1,783.138 ms