explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VGeN

Settings
# exclusive inclusive rows x rows loops node
1. 1,952.049 6,326.065 ↑ 1.0 1 1

Aggregate (cost=302,433.67..302,433.68 rows=1 width=9) (actual time=6,326.065..6,326.065 rows=1 loops=1)

2. 4,374.016 4,374.016 ↓ 1.2 4,570,066 1

Seq Scan on label_serial_no (cost=0.00..273,695.89 rows=3,831,704 width=9) (actual time=2.532..4,374.016 rows=4,570,066 loops=1)

  • Filter: (((customer)::text = 'Broadcom Singapore Pte Ltd'::text) AND ((label_type)::text = 'INNER-SERIAL'::text))
  • Rows Removed by Filter: 5727860
Planning time : 0.207 ms
Execution time : 6,326.104 ms