explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cUG

Settings
# exclusive inclusive rows x rows loops node
1. 34.817 55.724 ↑ 14.9 10,210 1

Nested Loop (cost=312.10..21,472.18 rows=152,426 width=192) (actual time=7.943..55.724 rows=10,210 loops=1)

2. 0.002 7.899 ↑ 4.0 1 1

Group (cost=311.54..311.56 rows=4 width=16) (actual time=7.897..7.899 rows=1 loops=1)

  • Group Key: "Endpoints".client
3. 0.015 7.897 ↑ 4.0 1 1

Sort (cost=311.54..311.55 rows=4 width=16) (actual time=7.896..7.897 rows=1 loops=1)

  • Sort Key: "Endpoints".client
  • Sort Method: quicksort Memory: 25kB
4. 7.882 7.882 ↑ 4.0 1 1

Seq Scan on "Endpoints" (cost=0.00..311.50 rows=4 width=16) (actual time=1.227..7.882 rows=1 loops=1)

  • Filter: ((inn)::text = '7716235373'::text)
  • Rows Removed by Filter: 13895
5. 13.008 13.008 ↑ 3.7 10,210 1

Index Scan using "Nomenclatures_client_nomenclature_idx" on "Nomenclatures" n (cost=0.56..4,718.54 rows=38,107 width=472) (actual time=0.020..13.008 rows=10,210 loops=1)

  • Index Cond: (client = "Endpoints".client)
Planning time : 0.345 ms
Execution time : 56.547 ms