explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dGEr

Settings
# exclusive inclusive rows x rows loops node
1. 250.345 2,760.677 ↑ 10.3 185,457 1

Finalize GroupAggregate (cost=978,916.94..1,448,356.51 rows=1,906,292 width=72) (actual time=1,685.210..2,760.677 rows=185,457 loops=1)

  • Group Key: rrdi_famille_eln_niveau, rrdi_code_fournisseur
2. 233.464 2,510.332 ↑ 5.9 487,950 1

Gather Merge (cost=978,916.94..1,355,002.88 rows=2,883,546 width=40) (actual time=1,685.190..2,510.332 rows=487,950 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 345.975 2,276.868 ↑ 8.9 162,650 3 / 3

Partial GroupAggregate (cost=977,916.91..1,021,170.10 rows=1,441,773 width=40) (actual time=1,656.730..2,276.868 rows=162,650 loops=3)

  • Group Key: rrdi_famille_eln_niveau, rrdi_code_fournisseur
4. 1,204.915 1,930.893 ↑ 1.2 1,183,271 3 / 3

Sort (cost=977,916.91..981,521.35 rows=1,441,773 width=30) (actual time=1,656.723..1,930.893 rows=1,183,271 loops=3)

  • Sort Key: rrdi_famille_eln_niveau, rrdi_code_fournisseur
  • Sort Method: external merge Disk: 49,352kB
5. 670.393 725.978 ↑ 1.2 1,183,271 3 / 3

Parallel Bitmap Heap Scan on rfid_registry_data_impacted rdi (cost=95,620.18..761,435.77 rows=1,441,773 width=30) (actual time=174.186..725.978 rows=1,183,271 loops=3)

  • Recheck Cond: ((tti_num_type_tiers_tir = 7) AND (tir_num_tiers_tir = 144))
  • Rows Removed by Index Recheck: 431,667
  • Heap Blocks: exact=16,409 lossy=33,587
6. 55.585 55.585 ↓ 1.0 3,549,846 1 / 3

Bitmap Index Scan on idx03_registry_data_impacted (cost=0.00..94,755.11 rows=3,460,255 width=0) (actual time=166.755..166.755 rows=3,549,846 loops=1)

  • Index Cond: ((tti_num_type_tiers_tir = 7) AND (tir_num_tiers_tir = 144))
Planning time : 0.165 ms
Execution time : 2,787.913 ms