explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bNH

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 330.440 ↓ 0.0 0 1

Limit (cost=2.01..175,770.78 rows=1 width=953) (actual time=330.440..330.440 rows=0 loops=1)

2. 0.001 330.438 ↓ 0.0 0 1

Nested Loop (cost=2.01..175,770.78 rows=1 width=953) (actual time=330.438..330.438 rows=0 loops=1)

3. 0.000 330.437 ↓ 0.0 0 1

Nested Loop (cost=1.44..175,768.71 rows=1 width=490) (actual time=330.437..330.437 rows=0 loops=1)

4. 0.001 330.437 ↓ 0.0 0 1

Nested Loop (cost=1.01..175,766.79 rows=1 width=136) (actual time=330.437..330.437 rows=0 loops=1)

5. 330.436 330.436 ↓ 0.0 0 1

Index Scan using message_migration_idx on "messagesMigration" (cost=0.43..175,763.98 rows=1 width=57) (actual time=330.436..330.436 rows=0 loops=1)

  • Index Cond: (migrated = true)
  • Filter: migrated
6. 0.000 0.000 ↓ 0.0 0

Index Scan using messages_pkey on messages message (cost=0.58..2.79 rows=1 width=79) (never executed)

  • Index Cond: (id = "messagesMigration"."messageId")
7. 0.000 0.000 ↓ 0.0 0

Index Scan using "Users_pkey" on users "message->user" (cost=0.43..1.91 rows=1 width=354) (never executed)

  • Index Cond: (id = message."userId")
8. 0.000 0.000 ↓ 0.0 0

Index Scan using conversations_pkey on conversations "message->conversation" (cost=0.57..2.06 rows=1 width=463) (never executed)

  • Index Cond: (id = message."conversationId")
Planning time : 1.765 ms
Execution time : 330.558 ms