explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pb67

Settings
# exclusive inclusive rows x rows loops node
1. 80.862 91.577 ↓ 1.9 71,557 1

Bitmap Heap Scan on ged_vm_stat_traitement_q (cost=2,003.96..179,410.33 rows=37,946 width=128) (actual time=13.625..91.577 rows=71,557 loops=1)

  • Recheck Cond: ((histo_operation_actor_fin IS NULL) AND ((sid_publie_in = 1) OR (sid_frachr_in = 1)))
  • Filter: ((histo_operation_date >= '2019-01-01 00:00:00'::timestamp without time zone) AND (sid_publie_in = 1))
  • Rows Removed by Filter: 13,234
  • Heap Blocks: exact=19,093
2. 10.715 10.715 ↑ 1.9 84,791 1

Bitmap Index Scan on idx_ged_vm_stat_traitement_q_3 (cost=0.00..1,994.47 rows=164,379 width=0) (actual time=10.715..10.715 rows=84,791 loops=1)

  • Index Cond: (histo_operation_actor_fin IS NULL)
Planning time : 1.299 ms
Execution time : 93.803 ms