explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5MxI

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 17.332 ↑ 1.0 1 1

Aggregate (cost=6,847.99..6,848.00 rows=1 width=8) (actual time=17.332..17.332 rows=1 loops=1)

2. 0.001 17.330 ↓ 0.0 0 1

Nested Loop (cost=0.29..6,847.99 rows=1 width=8) (actual time=17.330..17.330 rows=0 loops=1)

3. 17.329 17.329 ↓ 0.0 0 1

Seq Scan on single_customer_message_to_automatic_notification_settings automaticm0_ (cost=0.00..6,839.68 rows=1 width=16) (actual time=17.329..17.329 rows=0 loops=1)

  • Filter: (fk_automatic_notification_settings = 1,294,615,234)
  • Rows Removed by Filter: 190,516
4. 0.000 0.000 ↓ 0.0 0

Index Only Scan using automatic_notification_settings_pkey on automatic_notification_settings automaticn1_ (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (id = 1,294,615,234)
  • Heap Fetches: 0
Planning time : 0.558 ms
Execution time : 17.400 ms