explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VJMq

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 465.259 ↑ 1.0 20 1

Limit (cost=110,216.76..110,216.81 rows=20 width=1,515) (actual time=465.256..465.259 rows=20 loops=1)

2. 180.248 465.255 ↑ 39,857.9 40 1

Sort (cost=110,216.71..114,202.50 rows=1,594,315 width=1,515) (actual time=465.252..465.255 rows=40 loops=1)

  • Sort Key: date_realisation DESC, date_echeance
  • Sort Method: top-N heapsort Memory: 31kB
3. 285.007 285.007 ↓ 1.0 1,595,346 1

Seq Scan on crm_action actionenti0_ (cost=0.00..59,820.99 rows=1,594,315 width=1,515) (actual time=0.027..285.007 rows=1,595,346 loops=1)

  • Filter: ((type_echeance)::text = 'FAIT'::text)
  • Rows Removed by Filter: 38173
Planning time : 0.072 ms
Execution time : 465.277 ms