explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tqyj1

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.418 ↓ 0.0 0 1

Unique (cost=6,388.97..6,405.11 rows=3,227 width=174) (actual time=0.417..0.418 rows=0 loops=1)

  • Buffers: shared hit=101
2. 0.008 0.416 ↓ 0.0 0 1

Sort (cost=6,388.97..6,397.04 rows=3,227 width=174) (actual time=0.415..0.416 rows=0 loops=1)

  • Sort Key: po_infra_instan.id_infra_instan
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=101
3. 0.002 0.408 ↓ 0.0 0 1

Nested Loop (cost=28.61..6,200.90 rows=3,227 width=174) (actual time=0.408..0.408 rows=0 loops=1)

  • Buffers: shared hit=101
4. 0.001 0.406 ↓ 0.0 0 1

Nested Loop (cost=28.33..5,110.52 rows=3,227 width=174) (actual time=0.405..0.406 rows=0 loops=1)

  • Buffers: shared hit=101
5. 0.002 0.405 ↓ 0.0 0 1

Nested Loop (cost=28.03..4,023.00 rows=3,227 width=170) (actual time=0.404..0.405 rows=0 loops=1)

  • Buffers: shared hit=101
6. 0.002 0.403 ↓ 0.0 0 1

Nested Loop (cost=27.61..2,452.08 rows=3,229 width=166) (actual time=0.402..0.403 rows=0 loops=1)

  • Buffers: shared hit=101
7. 0.060 0.401 ↓ 0.0 0 1

Hash Join (cost=27.19..47.58 rows=3 width=8) (actual time=0.400..0.401 rows=0 loops=1)

  • Hash Cond: (po_connector_details.id_organization = org.id_organization)
  • Buffers: shared hit=101
8. 0.131 0.131 ↑ 1.0 53 1

Seq Scan on po_connector_details (cost=0.00..20.19 rows=53 width=12) (actual time=0.011..0.131 rows=53 loops=1)

  • Filter: (id_enterprise = 83)
  • Rows Removed by Filter: 202
  • Buffers: shared hit=17
9. 0.077 0.210 ↓ 4.4 70 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=84
10. 0.133 0.133 ↓ 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.006..0.133 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=84
11. 0.000 0.000 ↓ 0.0 0

Index Scan using index_po_infra_instan_id_connector_details on po_infra_instan (cost=0.42..785.82 rows=1,568 width=162) (never executed)

  • Index Cond: (id_connector_details = po_connector_details.id_connector_details)
  • Filter: (NOT bl_marked_for_deletion)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using index_po_proj_sub_infra_id_infra_instan on po_proj_sub_infra (cost=0.42..0.48 rows=1 width=8) (never executed)

  • Index Cond: (id_infra_instan = po_infra_instan.id_infra_instan)
13. 0.000 0.000 ↓ 0.0 0

Index Scan using po_project_sub_id_project_sub_key on po_project_sub (cost=0.29..0.33 rows=1 width=8) (never executed)

  • Index Cond: (id_project_sub = po_proj_sub_infra.id_project_sub)
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using po_project_pkey on po_project (cost=0.29..0.33 rows=1 width=4) (never executed)

  • Index Cond: (id_project = po_project_sub.id_project)
  • Heap Fetches: 0
Planning time : 0.978 ms
Execution time : 0.521 ms