explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9IeU

Settings
# exclusive inclusive rows x rows loops node
1. 45.462 71.014 ↑ 14.9 10,210 1

Nested Loop (cost=312.12..21,472.22 rows=152,426 width=192) (actual time=9.144..71.014 rows=10,210 loops=1)

2.          

CTE c

3. 0.003 9.082 ↑ 4.0 1 1

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

4. 0.013 9.079 ↑ 4.0 1 1

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

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

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

  • Filter: ((inn)::text = '7716235373'::text)
  • Rows Removed by Filter: 13,895
6. 9.085 9.085 ↑ 4.0 1 1

CTE Scan on c (cost=0.00..0.08 rows=4 width=16) (actual time=9.082..9.085 rows=1 loops=1)

7. 16.467 16.467 ↑ 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.028..16.467 rows=10,210 loops=1)

  • Index Cond: (client = c.client)
Planning time : 0.368 ms
Execution time : 72.569 ms