explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FeQz

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 64,008.441 ↑ 1.0 2 1

Limit (cost=0.43..31.06 rows=2 width=4) (actual time=64,008.437..64,008.441 rows=2 loops=1)

2. 15,151.901 64,008.439 ↑ 430,095.5 2 1

Nested Loop (cost=0.43..13,170,263.24 rows=860,191 width=4) (actual time=64,008.436..64,008.439 rows=2 loops=1)

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

Index Scan using lizard_nxt_label_pkey on lizard_nxt_label l (cost=0.43..12,963,815.30 rows=13,763,049 width=8) (actual time=0.589..35,420.382 rows=13,436,156 loops=1)

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

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

5. 0.019 0.019 ↑ 1.0 1 1

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

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