explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9gxu : "Nested Loop Left Join (cost=8.31..24.29 rows=1 width=4471) (actual time=0.136..0.186 rows=1 loops=1)" " Join Filter: ("TSOURCE_SYSTEM_3"."DFOBJ" = "TPRODUCT_CHARACTERISTIC_VALUE"."TSOURCE_SYSTEM")" " -> Nested Loop Left Join (cost=8.31..19.34 rows=1 width=4386) (actual time=0.119..0.169 rows=1 loops=1)" " -> Nested Loop Left Join (cost=8.17..16.64 rows=1 width=4301) (actual time=0.104..0.153 rows=1 loops=1)" " Join Filter: ("TVALUE_TYPE_1"."DFOBJ" = "TPRODUCT_CHARACTERISTIC_1"."TVALUE_TYPE")" " Rows Removed by Join Filter: 1" " -> Nested Loop Left Join (cost=8.17..15.46 rows=1 width=2737) (actual time=0.095..0.145 rows=1 loops=1)" " Join Filter: ("TPRODUCT_CHARACTERISTIC_1"."DFOBJ" = "TPRODUCT_CHARACTERISTIC_VALUE"."TPRODUCT_CHARACTERISTIC")" " -> Seq Scan on "TPRODUCT_CHARACTERISTIC_VALUE" (cost=0.00..2.31 rows=1 width=1080) (actual time=0.021..0.035 rows=1 loops=1)" " Filter: (("TPRODUCT_CHARACTERISTIC" = 10) AND ("TSOURCE_SYSTEM" = 70) AND (("DFCODE")::text = '" Супер-КАМ" (3К/ДНК)'::text))" " Rows Removed by Filter: 74" " -> Hash Right Join (cost=8.17..13.14 rows=1 width=1657) (actual time=0.071..0.106 rows=1 loops=1)" " Hash Cond: ("TSOURCE_SYSTEM_2"."DFOBJ" = "TPRODUCT_CHARACTERISTIC_1"."TSOURCE_SYSTEM")" " -> Seq Scan on "TSOURCE_SYSTEM" "TSOURCE_SYSTEM_2" (cost=0.00..4.55 rows=155 width=85) (actual time=0.007..0.032 rows=155 loops=1)" " -> Hash (cost=8.16..8.16 rows=1 width=1572) (actual time=0.030..0.031 rows=1 loops=1)" " Buckets: 1024 Batches: 1 Memory Usage: 9kB" " -> Index Scan using "TPRODUCT_CHARACTERISTIC_pkey" on "TPRODUCT_CHARACTERISTIC" "TPRODUCT_CHARACTERISTIC_1" (cost=0.14..8.16 rows=1 width=1572) (actual time=0.019..0.021 rows=1 loops=1)" " Index Cond: ("DFOBJ" = 10)" " -> Seq Scan on "TVALUE_TYPE" "TVALUE_TYPE_1" (cost=0.00..1.08 rows=8 width=1564) (actual time=0.005..0.005 rows=2 loops=1)" " -> Index Scan using "TSOURCE_SYSTEM_pkey" on "TSOURCE_SYSTEM" "TSOURCE_SYSTEM_1" (cost=0.14..2.66 rows=1 width=85) (actual time=0.012..0.012 rows=1 loops=1)" " Index Cond: ("DFOBJ" = "TVALUE_TYPE_1"."TSOURCE_SYSTEM")" " -> Seq Scan on "TSOURCE_SYSTEM" "TSOURCE_SYSTEM_3" (cost=0.00..4.94 rows=1 width=85) (actual time=0.014..0.015 rows=1 loops=1)" " Filter: ("DFOBJ" = 70)" " Rows Removed by Filter: 69" "Planning Time: 0.910 ms" "Execution Time: 0.323 ms"

Settings
# exclusive inclusive rows x rows loops node
1. 0.158 55.012 ↑ 11.4 71 1

Sort (cost=146.63..148.65 rows=808 width=138) (actual time=55.009..55.012 rows=71 loops=1)

  • Sort Key: n.nspname, p.proname, (pg_get_function_arguments(p.oid))
  • Sort Method: quicksort Memory: 43kB
2. 1.378 54.854 ↑ 11.4 71 1

Hash Join (cost=1.14..107.61 rows=808 width=138) (actual time=42.495..54.854 rows=71 loops=1)

  • Hash Cond: (p.pronamespace = n.oid)
3. 53.465 53.465 ↓ 3.0 2,402 1

Seq Scan on pg_proc p (cost=0.00..89.30 rows=808 width=78) (actual time=0.052..53.465 rows=2,402 loops=1)

  • Filter: pg_function_is_visible(oid)
4. 0.004 0.011 ↑ 1.0 4 1

Hash (cost=1.09..1.09 rows=4 width=68) (actual time=0.011..0.011 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
5. 0.007 0.007 ↑ 1.0 4 1

Seq Scan on pg_namespace n (cost=0.00..1.09 rows=4 width=68) (actual time=0.005..0.007 rows=4 loops=1)

  • Filter: ((nspname <> 'pg_catalog'::name) AND (nspname <> 'information_schema'::name))