explain.depesz.com

PostgreSQL's explain analyze made readable

Result: piMa

Settings
# exclusive inclusive rows x rows loops node
1. 0.854 702.350 ↑ 8.0 30 1

WindowAgg (cost=193,122.42..193,131.38 rows=239 width=151) (actual time=701.579..702.350 rows=30 loops=1)

2. 0.125 701.496 ↑ 8.0 30 1

Sort (cost=193,122.42..193,123.01 rows=239 width=88) (actual time=701.490..701.496 rows=30 loops=1)

  • Sort Key: implantations_id, data, ordem
  • Sort Method: quicksort Memory: 29kB
3. 701.371 701.371 ↑ 8.0 30 1

Seq Scan on movimentacoes m (cost=0.00..193,112.98 rows=239 width=88) (actual time=27.083..701.371 rows=30 loops=1)

  • Filter: (animal_id = 100,000,041)
  • Rows Removed by Filter: 2,411,014
Planning time : 0.295 ms
Execution time : 704.335 ms