explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8OVN

Settings
# exclusive inclusive rows x rows loops node
1. 147.508 259.215 ↓ 1.0 152,717 1

Append (cost=2,969.70..47,974.94 rows=149,842 width=71) (actual time=17.415..259.215 rows=152,717 loops=1)

2. 94.885 111.707 ↓ 1.0 152,717 1

Bitmap Heap Scan on part_contrat_lease_fact_3000_3500 (cost=2,969.70..47,225.73 rows=149,842 width=71) (actual time=17.413..111.707 rows=152,717 loops=1)

  • Recheck Cond: (contrat_id = 3058)
  • Heap Blocks: exact=3786
3. 16.822 16.822 ↓ 2.0 305,444 1

Bitmap Index Scan on part_contrat_lease_fact_3000_3500_contrat_id_idx (cost=0.00..2,932.24 rows=149,842 width=0) (actual time=16.821..16.822 rows=305,444 loops=1)

  • Index Cond: (contrat_id = 3058)