explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9m9W

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 97,838.742 ↑ 1.0 2 1

Limit (cost=0.43..30.99 rows=2 width=4) (actual time=97,838.732..97,838.742 rows=2 loops=1)

2. 32,880.150 97,838.736 ↑ 430,743.0 2 1

Nested Loop (cost=0.43..13,162,356.92 rows=861,486 width=4) (actual time=97,838.728..97,838.736 rows=2 loops=1)

  • Join Filter: (l.label_type_id = lt.id)
  • Rows Removed by Join Filter: 13436154
3. 51,522.430 51,522.430 ↑ 1.0 13,436,156 1

Index Scan using lizard_nxt_label_pkey on lizard_nxt_label l (cost=0.43..12,955,598.08 rows=13,783,776 width=8) (actual time=1.020..51,522.430 rows=13,436,156 loops=1)

4. 13,436.111 13,436.156 ↑ 1.0 1 13,436,156

Materialize (cost=0.00..2.21 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=13,436,156)

5. 0.045 0.045 ↑ 1.0 1 1

Seq Scan on lizard_nxt_labeltype lt (cost=0.00..2.20 rows=1 width=4) (actual time=0.030..0.045 rows=1 loops=1)

  • Filter: (uuid = '0303b5be-b50f-4871-8afb-e49af77cf724'::uuid)
  • Rows Removed by Filter: 15