explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FIAa

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 6.465 ↓ 0.0 0 1

Sort (cost=873.22..873.23 rows=2 width=22) (actual time=6.465..6.465 rows=0 loops=1)

  • Sort Key: date_invoice DESC, number DESC, id DESC
  • Sort Method: quicksort Memory: 25kB
2. 6.436 6.436 ↓ 0.0 0 1

Seq Scan on account_invoice (cost=0.00..873.21 rows=2 width=22) (actual time=6.436..6.436 rows=0 loops=1)

  • Filter: (active AND ((origin)::text ~~ '%SO0004141%'::text) AND (company_id = 1))
  • Rows Removed by Filter: 16023
Planning time : 0.551 ms
Execution time : 6.503 ms