explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6HeV

Settings
# exclusive inclusive rows x rows loops node
1. 365.592 16,362.638 ↓ 75.9 560,941 1

Subquery Scan on x (cost=5,919,149.69..6,220,066.49 rows=7,387 width=199) (actual time=13,741.229..16,362.638 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,660.186 15,997.046 ↓ 1.0 7,566,873 1

WindowAgg (cost=5,919,149.69..6,069,608.09 rows=7,522,920 width=199) (actual time=10,668.907..15,997.046 rows=7,566,873 loops=1)

3. 8,669.745 12,336.860 ↓ 1.0 7,566,873 1

Sort (cost=5,919,149.69..5,937,956.99 rows=7,522,920 width=155) (actual time=10,668.872..12,336.860 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,667.115 3,667.115 ↓ 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,713,532.00 rows=7,522,920 width=155) (actual time=0.023..3,667.115 rows=7,566,873 loops=1)

  • Filter: (sid_publie_in = 1)
Planning time : 0.717 ms
Execution time : 16,630.253 ms