explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9AQT

Settings
# exclusive inclusive rows x rows loops node
1. 32.170 61.856 ↑ 618.0 1 1

Nested Loop (cost=0.42..4,598.97 rows=618 width=68) (actual time=53.896..61.856 rows=1 loops=1)

2. 12.838 12.838 ↓ 1.0 624 1

Seq Scan on day day0_ (cost=0.00..491.52 rows=621 width=68) (actual time=1.004..12.838 rows=624 loops=1)

  • Filter: (registration = 4,483,594)
  • Rows Removed by Filter: 18,914
3. 16.848 16.848 ↓ 0.0 0 624

Index Scan using day_log_pkey on day_log daylog1_ (cost=0.42..6.60 rows=1 width=8) (actual time=0.027..0.027 rows=0 loops=624)

  • Index Cond: (id = day0_.day_log)
  • Filter: (opened OR (NOT report_printed))
  • Rows Removed by Filter: 1
Execution time : 61.941 ms