explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yT5T

Settings
# exclusive inclusive rows x rows loops node
1. 0.204 322,371.283 ↑ 6.4 68 1

Sort (cost=557,362.89..557,363.98 rows=433 width=20) (actual time=322,371.202..322,371.283 rows=68 loops=1)

  • Sort Key: ((po_monthly_flart_83.id_tseries)::date)
  • Sort Method: quicksort Memory: 30kB
2. 28,256.603 322,371.079 ↑ 6.4 68 1

HashAggregate (cost=557,334.19..557,343.93 rows=433 width=20) (actual time=322,370.956..322,371.079 rows=68 loops=1)

  • Group Key: (po_monthly_flart_83.id_tseries)::date
3. 48,864.609 294,114.476 ↓ 30.8 2,832,716 1

Hash Join (cost=18,868.69..556,413.41 rows=92,078 width=12) (actual time=12,576.671..294,114.476 rows=2,832,716 loops=1)

  • Hash Cond: (po_project.id_organization = po_organization.id_organization)
4. 46,345.085 245,248.660 ↓ 30.8 2,832,716 1

Hash Join (cost=18,851.98..554,900.43 rows=92,078 width=20) (actual time=12,575.447..245,248.660 rows=2,832,716 loops=1)

  • Hash Cond: (po_project_sub.id_project = po_project.id_project)
5. 50,131.238 198,211.175 ↓ 30.8 2,832,716 1

Hash Join (cost=17,523.34..552,305.72 rows=92,078 width=20) (actual time=11,882.664..198,211.175 rows=2,832,716 loops=1)

  • Hash Cond: (po_proj_sub_infra.id_project_sub = po_project_sub.id_project_sub)
6. 49,779.092 145,120.420 ↓ 30.8 2,832,716 1

Hash Join (cost=12,815.10..546,331.40 rows=92,078 width=20) (actual time=8,921.601..145,120.420 rows=2,832,716 loops=1)

  • Hash Cond: (po_monthly_flart_83.id_infra_instan = po_proj_sub_infra.id_infra_instan)
7. 87,247.779 87,247.779 ↓ 32.1 2,832,716 1

Seq Scan on po_monthly_flart_83 (cost=0.00..530,059.92 rows=88,195 width=20) (actual time=825.007..87,247.779 rows=2,832,716 loops=1)

  • Filter: (((id_tseries)::date >= '2018-01-01'::date) AND ((id_tseries)::date <= '2018-12-31'::date))
  • Rows Removed by Filter: 14,810,734
8. 3,554.499 8,093.549 ↓ 1.0 443,938 1

Hash (cost=7,266.71..7,266.71 rows=443,871 width=8) (actual time=8,093.548..8,093.549 rows=443,938 loops=1)

  • Buckets: 524,288 Batches: 1 Memory Usage: 21,438kB
9. 4,539.050 4,539.050 ↓ 1.0 443,938 1

Seq Scan on po_proj_sub_infra (cost=0.00..7,266.71 rows=443,871 width=8) (actual time=0.018..4,539.050 rows=443,938 loops=1)

10. 1,682.736 2,959.517 ↑ 1.0 140,174 1

Hash (cost=2,955.33..2,955.33 rows=140,233 width=8) (actual time=2,959.516..2,959.517 rows=140,174 loops=1)

  • Buckets: 262,144 Batches: 1 Memory Usage: 7,524kB
11. 1,276.781 1,276.781 ↑ 1.0 140,174 1

Seq Scan on po_project_sub (cost=0.00..2,955.33 rows=140,233 width=8) (actual time=0.017..1,276.781 rows=140,174 loops=1)

12. 309.697 692.400 ↑ 1.0 37,144 1

Hash (cost=863.84..863.84 rows=37,184 width=8) (actual time=692.399..692.400 rows=37,144 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 1,963kB
13. 382.703 382.703 ↑ 1.0 37,144 1

Seq Scan on po_project (cost=0.00..863.84 rows=37,184 width=8) (actual time=0.012..382.703 rows=37,144 loops=1)

14. 0.614 1.207 ↑ 1.1 415 1

Hash (cost=10.76..10.76 rows=476 width=4) (actual time=1.206..1.207 rows=415 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
15. 0.593 0.593 ↑ 1.1 415 1

Seq Scan on po_organization (cost=0.00..10.76 rows=476 width=4) (actual time=0.014..0.593 rows=415 loops=1)

Planning time : 3.808 ms
Execution time : 322,371.666 ms