explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Qx3

Settings
# exclusive inclusive rows x rows loops node
1. 1,769.227 2,069.692 ↑ 1.0 264,305 1

Sort (cost=54,774.14..55,444.99 rows=268,341 width=125) (actual time=2,035.973..2,069.692 rows=264,305 loops=1)

  • Sort Key: "PIT"."CODE", "PI"."NUMBER001", "PICL"."NUMBER001
  • Sort Method: external sort Disk: 34920kB
2. 71.832 300.465 ↑ 1.0 264,305 1

Nested Loop (cost=0.42..30,578.22 rows=268,341 width=125) (actual time=0.044..300.465 rows=264,305 loops=1)

3. 0.004 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.16 rows=1 width=85) (actual time=0.020..0.025 rows=1 loops=1)

  • Join Filter: ("PI"."TYPE001" = "PIT"."GUID")
4. 0.018 0.018 ↑ 1.0 1 1

Seq Scan on "PHYSICALINVENTORY" "PI" (cost=0.00..1.11 rows=1 width=81) (actual time=0.014..0.018 rows=1 loops=1)

  • Filter: ("GUID" = '0060d7e0-4401-2d10-acf2-0c0080650000'::uuid)
  • Rows Removed by Filter: 8
5. 0.003 0.003 ↑ 2.0 1 1

Seq Scan on "PHYSICALINVENTORYTYPE" "PIT" (cost=0.00..1.02 rows=2 width=20) (actual time=0.003..0.003 rows=1 loops=1)

6. 228.608 228.608 ↑ 1.0 264,305 1

Index Scan using "I10GJ5B7C0400CIS" on "PHYSICALINVENTORYCOUNTLIST" "PICL" (cost=0.42..27,892.65 rows=268,341 width=40) (actual time=0.021..228.608 rows=264,305 loops=1)

  • Index Cond: ("INVENTORY" = '0060d7e0-4401-2d10-acf2-0c0080650000'::uuid)
Planning time : 0.519 ms
Execution time : 2,082.988 ms