explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2dQT

Settings
# exclusive inclusive rows x rows loops node
1. 169.565 2,390.328 ↓ 6.2 82,454 1

Unique (cost=28,038.73..28,104.81 rows=13,215 width=174) (actual time=2,121.621..2,390.328 rows=82,454 loops=1)

  • Buffers: shared hit=3,222 read=11,179, temp read=2,297 written=2,295
2. 236.179 2,220.763 ↓ 6.4 84,268 1

Sort (cost=28,038.73..28,071.77 rows=13,215 width=174) (actual time=2,121.617..2,220.763 rows=84,268 loops=1)

  • Sort Key: po_infra_instan.id_infra_instan
  • Sort Method: external merge Disk: 11,512kB
  • Buffers: shared hit=3,222 read=11,179, temp read=2,297 written=2,295
3. 217.470 1,984.584 ↓ 6.4 84,268 1

Hash Join (cost=10,514.35..27,134.17 rows=13,215 width=174) (actual time=1,030.234..1,984.584 rows=84,268 loops=1)

  • Hash Cond: (po_infra_instan.id_infra_instan = po_proj_sub_infra.id_infra_instan)
  • Buffers: shared hit=3,222 read=11,179, temp read=854 written=852
4. 366.032 737.289 ↓ 1.5 84,771 1

Hash Join (cost=20.85..15,581.51 rows=57,047 width=162) (actual time=0.214..737.289 rows=84,771 loops=1)

  • Hash Cond: (po_infra_instan.id_connector_details = po_connector_details.id_connector_details)
  • Buffers: shared hit=52 read=11,179
5. 371.069 371.069 ↑ 1.0 274,442 1

Seq Scan on po_infra_instan (cost=0.00..13,960.92 rows=274,472 width=162) (actual time=0.017..371.069 rows=274,442 loops=1)

  • Filter: (NOT bl_marked_for_deletion)
  • Rows Removed by Filter: 233
  • Buffers: shared hit=35 read=11,179
6. 0.058 0.188 ↑ 1.0 53 1

Hash (cost=20.19..20.19 rows=53 width=4) (actual time=0.187..0.188 rows=53 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=17
7. 0.130 0.130 ↑ 1.0 53 1

Seq Scan on po_connector_details (cost=0.00..20.19 rows=53 width=4) (actual time=0.007..0.130 rows=53 loops=1)

  • Filter: (id_enterprise = 83)
  • Rows Removed by Filter: 202
  • Buffers: shared hit=17
8. 97.910 1,029.825 ↓ 1.3 84,697 1

Hash (cost=9,698.11..9,698.11 rows=63,631 width=16) (actual time=1,029.824..1,029.825 rows=84,697 loops=1)

  • Buckets: 131,072 (originally 65536) Batches: 2 (originally 1) Memory Usage: 3,073kB
  • Buffers: shared hit=3,170, temp written=185
9. 376.181 931.915 ↓ 1.3 84,697 1

Hash Join (cost=3,538.13..9,698.11 rows=63,631 width=16) (actual time=282.260..931.915 rows=84,697 loops=1)

  • Hash Cond: (po_proj_sub_infra.id_project_sub = po_project_sub.id_project_sub)
  • Buffers: shared hit=3,170
10. 273.734 273.734 ↓ 1.0 274,533 1

Seq Scan on po_proj_sub_infra (cost=0.00..4,494.22 rows=274,522 width=8) (actual time=0.006..273.734 rows=274,533 loops=1)

  • Buffers: shared hit=1,749
11. 10.738 282.000 ↑ 2.1 9,532 1

Hash (cost=3,291.11..3,291.11 rows=19,762 width=12) (actual time=281.999..282.000 rows=9,532 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 666kB
  • Buffers: shared hit=1,421
12. 99.693 271.262 ↑ 2.1 9,532 1

Hash Join (cost=989.16..3,291.11 rows=19,762 width=12) (actual time=85.622..271.262 rows=9,532 loops=1)

  • Hash Cond: (po_project_sub.id_project = po_project.id_project)
  • Buffers: shared hit=1,421
13. 85.972 85.972 ↓ 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.006..85.972 rows=85,261 loops=1)

  • Buffers: shared hit=932
14. 13.369 85.597 ↓ 1.8 12,498 1

Hash (cost=904.15..904.15 rows=6,801 width=8) (actual time=85.596..85.597 rows=12,498 loops=1)

  • Buckets: 16,384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 617kB
  • Buffers: shared hit=489
15. 42.953 72.228 ↓ 1.8 12,498 1

Hash Join (cost=27.69..904.15 rows=6,801 width=8) (actual time=0.770..72.228 rows=12,498 loops=1)

  • Hash Cond: (po_project.id_organization = org.id_organization)
  • Buffers: shared hit=489
16. 29.079 29.079 ↓ 1.0 29,343 1

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

  • Buffers: shared hit=405
17. 0.074 0.196 ↑ 1.0 70 1

Hash (cost=26.81..26.81 rows=70 width=4) (actual time=0.195..0.196 rows=70 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=84
18. 0.122 0.122 ↑ 1.0 70 1

Index Only Scan using po_organization_pkey on po_organization org (cost=0.15..26.81 rows=70 width=4) (actual time=0.006..0.122 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[]))
  • Heap Fetches: 70
  • Buffers: shared hit=84
Planning time : 1.057 ms
Execution time : 2,470.828 ms