explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YayV

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

Aggregate (cost=720.84..720.85 rows=1 width=8) (actual time=651.506..651.506 rows=1 loops=1)

2. 422.865 651.502 ↓ 0.0 0 1

Bitmap Heap Scan on cagnottemvt (cost=483.84..720.84 rows=1 width=16) (actual time=651.502..651.502 rows=0 loops=1)

  • Recheck Cond: ((cagnottemvt_type = 0) AND (cagnottemvt_etat = 0))
  • Filter: ((cagnottemvt_valeur <> cagnottemvt_valeurconso) AND (cagnottemvt_dossier_id = 85) AND (cagnottemvt_cagnotte_id = 641,628) AND (cagnottemvt_debut <= now()) AND (cagnottemvt_fin >= CURRENT_DATE))
  • Rows Removed by Filter: 1,888,006
  • Heap Blocks: exact=78,140
3. 2.705 228.637 ↓ 0.0 0 1

BitmapAnd (cost=483.84..483.84 rows=60 width=0) (actual time=228.637..228.637 rows=0 loops=1)

4. 114.783 114.783 ↓ 158.5 1,888,742 1

Bitmap Index Scan on cagnottemvt_type_sk (cost=0.00..241.79 rows=11,915 width=0) (actual time=114.783..114.783 rows=1,888,742 loops=1)

  • Index Cond: (cagnottemvt_type = 0)
5. 111.149 111.149 ↓ 226.7 2,700,787 1

Bitmap Index Scan on cagnottemvt_etat_sk (cost=0.00..241.79 rows=11,915 width=0) (actual time=111.148..111.149 rows=2,700,787 loops=1)

  • Index Cond: (cagnottemvt_etat = 0)