explain.depesz.com

PostgreSQL's explain analyze made readable

Result: haup

Settings
# exclusive inclusive rows x rows loops node
1. 42.762 903.385 ↓ 1.9 71,557 1

Gather (cost=1,000.43..4,570,180.90 rows=38,460 width=128) (actual time=0.956..903.385 rows=71,557 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
2. 860.623 860.623 ↓ 1.6 10,222 7 / 7

Parallel Index Scan using idx_ged_vm_stat_traitement_q_1 on ged_vm_stat_traitement_q (cost=0.43..4,565,334.90 rows=6,410 width=128) (actual time=0.892..860.623 rows=10,222 loops=7)

  • Filter: ((histo_operation_actor_fin IS NULL) AND (histo_operation_date >= '2019-01-01 00:00:00'::timestamp without time zone) AND (sid_publie_in = 1))
  • Rows Removed by Filter: 1,070,759
Planning time : 0.897 ms
Execution time : 905.892 ms