explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7h3B : Versão com LIMIT 40

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 19,418.414 ↑ 1.7 23 1

Limit (cost=0.00..8.14 rows=40 width=717) (actual time=3,359.910..19,418.414 rows=23 loops=1)

2. 19,418.389 19,418.389 ↑ 412,384.9 23 1

Seq Scan on cdr_spool (cost=0.00..1,930,202.10 rows=9,484,853 width=717) (actual time=3,359.907..19,418.389 rows=23 loops=1)

  • Filter: ((status = 2) AND ((billing = 0) OR (billing = 99)))
  • Rows Removed by Filter: 38,976,668
Planning time : 0.201 ms
Execution time : 19,418.962 ms