explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nqEg

Settings
# exclusive inclusive rows x rows loops node
1. 0.080 323.920 ↑ 1.0 1 1

Aggregate (cost=15,286.50..15,286.51 rows=1 width=8) (actual time=323.920..323.920 rows=1 loops=1)

2. 0.349 323.840 ↓ 1.3 36 1

Nested Loop (cost=0.99..15,286.43 rows=27 width=0) (actual time=9.589..323.840 rows=36 loops=1)

3. 0.443 0.443 ↑ 3.4 44 1

Index Scan using message_type_359c46_idx on message (cost=0.43..11.29 rows=148 width=4) (actual time=0.129..0.443 rows=44 loops=1)

  • Index Cond: (type = 2)
  • Filter: (send_datetime IS NOT NULL)
4. 323.048 323.048 ↑ 5.0 1 44

Index Scan using message_recipient_message_id on message_recipient (cost=0.56..103.16 rows=5 width=4) (actual time=4.844..7.342 rows=1 loops=44)

  • Index Cond: (message_id = message.id)
  • Filter: ((NOT deleted) AND (NOT read) AND (read_datetime IS NULL) AND (to_user_id = 7219))
  • Rows Removed by Filter: 12076
Planning time : 1.318 ms
Execution time : 324.056 ms