explain.depesz.com

PostgreSQL's explain analyze made readable

Result: poSy

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

Limit (cost=618,802.75..618,802.86 rows=1 width=16) (actual time=23,439.221..23,439.222 rows=1 loops=1)

2. 12.237 23,440.941 ↑ 428.0 1 1

Gather Merge (cost=618,802.75..618,852.68 rows=428 width=16) (actual time=23,439.219..23,440.941 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.544 23,428.704 ↑ 214.0 1 3 / 3

Sort (cost=617,802.72..617,803.26 rows=214 width=16) (actual time=23,428.704..23,428.704 rows=1 loops=3)

  • Sort Key: played DESC
  • 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
4. 23,428.160 23,428.160 ↑ 2.0 109 3 / 3

Parallel Seq Scan on words_moves (cost=0.00..617,801.65 rows=214 width=16) (actual time=71.333..23,428.160 rows=109 loops=3)

  • Filter: (puzzle IS TRUE)
  • Rows Removed by Filter: 1,707,814
Planning time : 0.307 ms
Execution time : 23,441.033 ms