explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P1v4

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 3,810.715 ↑ 1.0 1 1

Limit (cost=300,912.91..300,912.93 rows=1 width=9) (actual time=3,810.715..3,810.715 rows=1 loops=1)

2. 1,117.310 3,810.713 ↑ 1.0 1 1

Aggregate (cost=300,912.91..300,912.93 rows=1 width=9) (actual time=3,810.713..3,810.713 rows=1 loops=1)

3. 2,693.403 2,693.403 ↓ 1.2 4,565,968 1

Seq Scan on label_serial_no (cost=0.00..272,326.47 rows=3,811,526 width=9) (actual time=3.007..2,693.403 rows=4,565,968 loops=1)

  • Filter: (((customer)::text = 'Broadcom Singapore Pte Ltd'::text) AND ((label_type)::text = 'INNER-SERIAL'::text))
  • Rows Removed by Filter: 5682785
Planning time : 0.268 ms
Execution time : 3,810.813 ms