explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8jHi

Settings
# exclusive inclusive rows x rows loops node
1. 161.538 1,932.865 ↓ 27.3 82,454 1

Unique (cost=17,308.37..17,323.48 rows=3,021 width=174) (actual time=1,676.416..1,932.865 rows=82,454 loops=1)

  • Buffers: shared hit=398633 read=8343 written=2120, temp read=1443 written=1443
2. 252.862 1,771.327 ↓ 27.9 84,268 1

Sort (cost=17,308.37..17,315.93 rows=3,021 width=174) (actual time=1,676.412..1,771.327 rows=84,268 loops=1)

  • Sort Key: po_proj_sub_infra.id_infra_instan
  • Sort Method: external merge Disk: 11520kB
  • Buffers: shared hit=398633 read=8343 written=2120, temp read=1443 written=1443
3. 176.577 1,518.465 ↓ 27.9 84,268 1

Hash Join (cost=892.32..17,133.75 rows=3,021 width=174) (actual time=85.214..1,518.465 rows=84,268 loops=1)

  • Hash Cond: (po_infra_instan.id_connector_details = po_connector_details.id_connector_details)
  • Buffers: shared hit=398633 read=8343 written=2120
4. 318.500 1,341.638 ↓ 5.8 84,268 1

Nested Loop (cost=871.47..17,028.18 rows=14,535 width=178) (actual time=84.955..1,341.638 rows=84,268 loops=1)

  • Buffers: shared hit=398632 read=8327 written=2120
5. 185.728 599.653 ↓ 5.8 84,697 1

Nested Loop (cost=871.05..7,944.86 rows=14,547 width=20) (actual time=84.930..599.653 rows=84,697 loops=1)

  • Buffers: shared hit=65092 read=2613 written=564
6. 98.186 270.945 ↓ 2.1 9,532 1

Hash Join (cost=870.63..3,020.13 rows=4,518 width=16) (actual time=84.898..270.945 rows=9,532 loops=1)

  • Hash Cond: (po_project_sub.id_project = po_project.id_project)
  • Buffers: shared hit=85 read=1336 written=216
7. 87.884 87.884 ↓ 1.0 85,261 1

Seq Scan on po_project_sub (cost=0.00..1,784.60 rows=85,260 width=8) (actual time=0.012..87.884 rows=85,261 loops=1)

  • Buffers: shared hit=1 read=931 written=216
8. 13.001 84.875 ↓ 8.0 12,498 1

Hash (cost=851.19..851.19 rows=1,555 width=12) (actual time=84.874..84.875 rows=12,498 loops=1)

  • Buckets: 16384 (originally 2048) Batches: 1 (originally 1) Memory Usage: 666kB
  • Buffers: shared hit=84 read=405
9. 41.910 71.874 ↓ 8.0 12,498 1

Hash Join (cost=27.19..851.19 rows=1,555 width=12) (actual time=0.808..71.874 rows=12,498 loops=1)

  • Hash Cond: (po_project.id_organization = org.id_organization)
  • Buffers: shared hit=84 read=405
10. 29.747 29.747 ↓ 1.0 29,343 1

Seq Scan on po_project (cost=0.00..698.42 rows=29,342 width=8) (actual time=0.010..29.747 rows=29,343 loops=1)

  • Buffers: shared hit=2 read=403
11. 0.074 0.217 ↓ 4.4 70 1

Hash (cost=26.99..26.99 rows=16 width=8) (actual time=0.216..0.217 rows=70 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=82 read=2
12. 0.143 0.143 ↓ 4.4 70 1

Index Scan using po_organization_pkey on po_organization org (cost=0.15..26.99 rows=16 width=8) (actual time=0.012..0.143 rows=70 loops=1)

  • Index Cond: (id_organization = ANY ('{126,133,190,191,192,193,194,195,196,197,198,199,203,204,211,272,287,288,289,290,291,292,293,331,333,337,338,339,340,341,342,347,349,350,351,352,353,354,355,356,361,362,363,366,367,368,369,373,374,375,376,377,378,379,380,381,382,383,384,385,386,396,397,398,399,400,401,402,403,424}'::integer[]))
  • Filter: (id_enterprise = 83)
  • Buffers: shared hit=82 read=2
13. 142.980 142.980 ↑ 2.2 9 9,532

Index Scan using index_po_proj_sub_infra_id_project_sub on po_proj_sub_infra (cost=0.42..0.89 rows=20 width=8) (actual time=0.003..0.015 rows=9 loops=9,532)

  • Index Cond: (id_project_sub = po_project_sub.id_project_sub)
  • Buffers: shared hit=65007 read=1277 written=348
14. 423.485 423.485 ↑ 1.0 1 84,697

Index Scan using po_infra_instan_pkey on po_infra_instan (cost=0.42..0.61 rows=1 width=162) (actual time=0.004..0.005 rows=1 loops=84,697)

  • Index Cond: (id_infra_instan = po_proj_sub_infra.id_infra_instan)
  • Filter: (NOT bl_marked_for_deletion)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=333540 read=5714 written=1556
15. 0.058 0.250 ↑ 1.0 53 1

Hash (cost=20.19..20.19 rows=53 width=8) (actual time=0.249..0.250 rows=53 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1 read=16
16. 0.192 0.192 ↑ 1.0 53 1

Seq Scan on po_connector_details (cost=0.00..20.19 rows=53 width=8) (actual time=0.015..0.192 rows=53 loops=1)

  • Filter: (id_enterprise = 83)
  • Rows Removed by Filter: 202
  • Buffers: shared hit=1 read=16
Planning time : 1.705 ms
Execution time : 2,009.478 ms