explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 25JG

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

Sort (cost=64,757.03..65,427.88 rows=268,341 width=125) (actual time=2,123.067..2,158.607 rows=264,305 loops=1)

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

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

3. 0.004 0.021 ↑ 1.0 1 1

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

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

Seq Scan on "PHYSICALINVENTORY" "PI" (cost=0.00..1.11 rows=1 width=81) (actual time=0.012..0.014 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. 270.654 270.654 ↑ 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.049..270.654 rows=264,305 loops=1)

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