explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ANU5

Settings
# exclusive inclusive rows x rows loops node
1. 36.659 58.186 ↑ 14.9 10,210 1

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

2. 0.002 8.163 ↑ 4.0 1 1

Unique (cost=311.54..311.56 rows=4 width=16) (actual time=8.161..8.163 rows=1 loops=1)

3. 0.013 8.161 ↑ 4.0 1 1

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

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

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

  • Filter: ((inn)::text = '7716235373'::text)
  • Rows Removed by Filter: 13895
5. 13.364 13.364 ↑ 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.025..13.364 rows=10,210 loops=1)

  • Index Cond: (client = "Endpoints".client)
Planning time : 0.406 ms
Execution time : 58.877 ms