explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cDYr

Settings
# exclusive inclusive rows x rows loops node
1. 42.123 64.795 ↑ 14.9 10,210 1

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

2. 0.002 8.131 ↑ 4.0 1 1

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

3. 0.013 8.129 ↑ 4.0 1 1

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

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

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

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

  • Index Cond: (client = "Endpoints".client)
Planning time : 0.381 ms
Execution time : 65.846 ms