explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Njtv

Settings
# exclusive inclusive rows x rows loops node
1. 4,482.898 4,482.898 ↑ 1.0 1 1

"Seq Scan on lab_job (cost=0.00..1,082,603.85 rows=1 width=1,760) (actual time=2,172.339..4,482.898 rows=1 loops=1)

  • Filter: (((tracking_number)::text = 'RX0007926028'::text) AND ((current_job_sequence)::text = '2'::text))
  • Rows Removed by Filter: 12,380,294
Planning time : 0.278 ms
Execution time : 4,482.973 ms