explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1YE5 : Versão sem limit

Settings
# exclusive inclusive rows x rows loops node
1. 1.955 5.070 ↑ 592,803.3 16 1

Bitmap Heap Scan on cdr_spool (cost=286,352.09..1,700,569.02 rows=9,484,853 width=717) (actual time=3.218..5.070 rows=16 loops=1)

  • Recheck Cond: (((status = 2) AND (billing = 0)) OR (billing = 99))
  • Filter: (status = 2)
  • Rows Removed by Filter: 27
  • Heap Blocks: exact=60
2. 0.007 3.115 ↓ 0.0 0 1

BitmapOr (cost=286,352.09..286,352.09 rows=9,484,853 width=0) (actual time=3.115..3.115 rows=0 loops=1)

3. 0.314 0.314 ↑ 287,419.8 33 1

Bitmap Index Scan on ix_cdr_ativo_status_billing (cost=0.00..281,605.10 rows=9,484,853 width=0) (actual time=0.314..0.314 rows=33 loops=1)

  • Index Cond: ((status = 2) AND (billing = 0))
4. 2.794 2.794 ↓ 27.0 27 1

Bitmap Index Scan on ix_cdr_ativo_billing_desc (cost=0.00..4.57 rows=1 width=0) (actual time=2.794..2.794 rows=27 loops=1)

  • Index Cond: (billing = 99)
Planning time : 0.373 ms
Execution time : 5.546 ms