explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E8ae

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,043.434 ↑ 1.0 1 1

Limit (cost=0.00..277,070.60 rows=1 width=1,037) (actual time=785.913..1,043.434 rows=1 loops=1)

2. 1,043.431 1,043.431 ↑ 1.0 1 1

Seq Scan on sys_request_log request0_ (cost=0.00..277,070.60 rows=1 width=1,037) (actual time=785.911..1,043.431 rows=1 loops=1)

  • Filter: ((inquiry_request_id)::text = 'EGRP3106466'::text)
  • Rows Removed by Filter: 1217710
Planning time : 1.441 ms
Execution time : 1,043.498 ms