explain.depesz.com

PostgreSQL's explain analyze made readable

Result: itLF

Settings
# exclusive inclusive rows x rows loops node
1. 364.354 16,211.696 ↓ 76.5 560,941 1

Subquery Scan on x (cost=5,907,076.00..6,210,848.08 rows=7,337 width=199) (actual time=13,592.717..16,211.696 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,652.211 15,847.342 ↑ 1.0 7,566,873 1

WindowAgg (cost=5,907,076.00..6,058,962.04 rows=7,594,302 width=199) (actual time=10,509.647..15,847.342 rows=7,566,873 loops=1)

3. 8,530.507 12,195.131 ↑ 1.0 7,566,873 1

Sort (cost=5,907,076.00..5,926,061.75 rows=7,594,302 width=155) (actual time=10,509.615..12,195.131 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,664.624 3,664.624 ↑ 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,689,499.91 rows=7,594,302 width=155) (actual time=0.022..3,664.624 rows=7,566,873 loops=1)

  • Filter: (sid_publie_in = 1)
Planning time : 1.619 ms
Execution time : 16,490.673 ms