explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cjhk

Settings
# exclusive inclusive rows x rows loops node
1. 139.323 184.652 ↑ 1.1 152,747 1

Gather (cost=4,880.13..524,086.83 rows=174,395 width=71) (actual time=13.326..184.652 rows=152,747 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 32.698 45.329 ↑ 1.4 50,916 3

Parallel Bitmap Heap Scan on lease_fact (cost=3,880.13..505,647.33 rows=72,665 width=71) (actual time=4.802..45.329 rows=50,916 loops=3)

  • Recheck Cond: (contrat_id = 3058)
  • Heap Blocks: exact=24
3. 12.631 12.631 ↑ 1.1 152,747 1

Bitmap Index Scan on idx_lease_fact_contrat_id (cost=0.00..3,836.53 rows=174,395 width=0) (actual time=12.631..12.631 rows=152,747 loops=1)

  • Index Cond: (contrat_id = 3058)