explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YLeC

Settings
# exclusive inclusive rows x rows loops node
1. 0.547 132,075.924 ↑ 1.0 100 1

Sort (cost=3,325,140.38..3,325,140.63 rows=100 width=214) (actual time=132,075.910..132,075.924 rows=100 loops=1)

  • Sort Key: filelevelflartdata."flartPct" DESC NULLS LAST
  • Sort Method: quicksort Memory: 48kB
2.          

CTE filelevelflartdata

3. 0.011 132,067.621 ↑ 1.0 100 1

Limit (cost=3,324,275.79..3,324,276.54 rows=100 width=179) (actual time=132,067.497..132,067.621 rows=100 loops=1)

4. 0.037 132,067.610 ↑ 249.9 100 1

Unique (cost=3,324,275.79..3,324,463.21 rows=24,989 width=179) (actual time=132,067.495..132,067.610 rows=100 loops=1)

5. 38,507.788 132,067.573 ↑ 177.2 141 1

Sort (cost=3,324,275.79..3,324,338.26 rows=24,989 width=179) (actual time=132,067.494..132,067.573 rows=141 loops=1)

  • Sort Key: mv_flart.tx_working_file, mv_flart.id_infra_instan, mv_flart.id_tseries DESC
  • Sort Method: external merge Disk: 423,488kB
6. 3,418.732 93,559.785 ↓ 96.1 2,401,995 1

Hash Join (cost=1,689.69..3,322,450.47 rows=24,989 width=179) (actual time=27,321.981..93,559.785 rows=2,401,995 loops=1)

  • Hash Cond: (mv_flart.id_infra_instan = po_proj_sub_infra.id_infra_instan)
7. 2,618.251 90,020.620 ↑ 1.0 35,661,959 1

Append (cost=0.00..2,963,642.76 rows=35,674,289 width=175) (actual time=27,181.813..90,020.620 rows=35,661,959 loops=1)

8. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on mv_flart (cost=0.00..0.00 rows=1 width=132) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((id_enterprise = 83) AND (id_tseries <= ('now'::cstring)::date))
9. 87,402.366 87,402.366 ↑ 1.0 35,661,959 1

Seq Scan on mv_flart_83 (cost=0.00..2,963,642.76 rows=35,674,288 width=175) (actual time=27,181.810..87,402.366 rows=35,661,959 loops=1)

  • Filter: ((id_enterprise = 83) AND (id_tseries <= ('now'::cstring)::date))
10. 0.734 120.433 ↓ 13.4 3,998 1

Hash (cost=1,685.97..1,685.97 rows=298 width=4) (actual time=120.433..120.433 rows=3,998 loops=1)

  • Buckets: 4,096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 173kB
11. 0.585 119.699 ↓ 13.4 3,998 1

Nested Loop (cost=0.84..1,685.97 rows=298 width=4) (actual time=4.671..119.699 rows=3,998 loops=1)

12. 21.166 21.166 ↑ 1.0 94 1

Index Scan using po_project_sub_id_project on po_project_sub (cost=0.42..165.76 rows=94 width=4) (actual time=2.366..21.166 rows=94 loops=1)

  • Index Cond: (id_project = 10,450)
13. 97.948 97.948 ↓ 7.2 43 94

Index Scan using index_po_proj_sub_infra_id_project_sub on po_proj_sub_infra (cost=0.42..16.11 rows=6 width=8) (actual time=0.456..1.042 rows=43 loops=94)

  • Index Cond: (id_project_sub = po_project_sub.id_project_sub)
14. 0.047 132,075.377 ↑ 1.0 100 1

Nested Loop Left Join (cost=0.57..860.51 rows=100 width=214) (actual time=132,070.853..132,075.377 rows=100 loops=1)

15. 0.067 132,075.330 ↑ 1.0 100 1

Nested Loop (cost=0.42..843.00 rows=100 width=214) (actual time=132,070.847..132,075.330 rows=100 loops=1)

16. 132,067.663 132,067.663 ↑ 1.0 100 1

CTE Scan on filelevelflartdata (cost=0.00..2.00 rows=100 width=128) (actual time=132,067.500..132,067.663 rows=100 loops=1)

17. 7.600 7.600 ↑ 1.0 1 100

Index Scan using po_infra_instan_pkey on po_infra_instan infrainstandata (cost=0.42..8.40 rows=1 width=90) (actual time=0.076..0.076 rows=1 loops=100)

  • Index Cond: (id_infra_instan = filelevelflartdata."infraId")
18. 0.000 0.000 ↓ 0.0 0 100

Index Scan using po_discovery_config_id_discovery_config_uindex on po_discovery_config discoveryconfig (cost=0.15..0.17 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=100)

  • Index Cond: (infrainstandata.id_config = id_config)
Planning time : 275.939 ms
Execution time : 132,142.435 ms