explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xlIA

Settings
# exclusive inclusive rows x rows loops node
1. 43.525 67.610 ↑ 14.9 10,210 1

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

2. 0.002 8.667 ↑ 4.0 1 1

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

3. 0.017 8.665 ↑ 4.0 1 1

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

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

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

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

  • Index Cond: (client = "Endpoints".client)
Planning time : 0.427 ms
Execution time : 68.638 ms