explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GUJc

Settings
# exclusive inclusive rows x rows loops node
1. 367.189 16,221.184 ↓ 74.7 560,941 1

Subquery Scan on x (cost=5,939,099.47..6,248,091.59 rows=7,513 width=199) (actual time=13,612.674..16,221.184 rows=560,941 loops=1)

  • Filter: ((x.date_heure >= '2019-01-01 00:00:00'::timestamp without time zone) AND (x.rn = 1) AND ((x.doc_entrant_in)::text = 'O'::text) AND ((x.typo_domaine)::text = 'PROD'::text))
  • Rows Removed by Filter: 7,005,932
2. 3,641.675 15,853.995 ↑ 1.0 7,566,873 1

WindowAgg (cost=5,939,099.47..6,093,595.53 rows=7,724,803 width=199) (actual time=10,528.691..15,853.995 rows=7,566,873 loops=1)

3. 8,574.818 12,212.320 ↑ 1.0 7,566,873 1

Sort (cost=5,939,099.47..5,958,411.48 rows=7,724,803 width=155) (actual time=10,528.658..12,212.320 rows=7,566,873 loops=1)

  • Sort Key: ged_vm_stat_traitement_q.tre_key, ged_vm_stat_traitement_q.histo_operation_date
  • Sort Method: external merge Disk: 1,266,144kB
4. 3,637.502 3,637.502 ↑ 1.0 7,566,873 1

Index Scan using idx_ged_vm_stat_traitement_q_1 on ged_vm_stat_traitement_q (cost=0.43..4,699,651.46 rows=7,724,803 width=155) (actual time=0.028..3,637.502 rows=7,566,873 loops=1)

  • Filter: (sid_publie_in = 1)
Planning time : 1.564 ms
Execution time : 16,498.453 ms