explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HUIZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 8,718.867 ↑ 1.0 10 1

Limit (cost=0.44..104.01 rows=10 width=33) (actual time=8,704.466..8,718.867 rows=10 loops=1)

2. 0.000 8,718.863 ↑ 11,085.1 10 1

Nested Loop (cost=0.44..1,148,112.61 rows=110,851 width=33) (actual time=8,704.465..8,718.863 rows=10 loops=1)

3. 2,330.736 2,330.736 ↑ 2.4 6,983,582 1

Index Scan Backward using service_discover_time on service s (cost=0.44..672,172.55 rows=16,966,402 width=33) (actual time=0.092..2,330.736 rows=6,983,582 loops=1)

4. 6,983.582 6,983.582 ↓ 0.0 0 6,983,582

Index Scan using idx_title on title t (cost=0.00..0.02 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=6,983,582)

  • Index Cond: (blob = s.blob)
  • Rows Removed by Index Recheck: 0