explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l3pG

Settings
# exclusive inclusive rows x rows loops node
1. 17.770 121.026 ↑ 1.0 10,000 1

Limit (cost=0.00..1,546.71 rows=10,000 width=14) (actual time=0.016..121.026 rows=10,000 loops=1)

2. 42.832 103.256 ↑ 37.6 10,000 1

Seq Scan on uat_device (cost=0.00..58,121.62 rows=375,775 width=14) (actual time=0.014..103.256 rows=10,000 loops=1)

  • Filter: (dvc_role <> ALL ('{1,3,4,5,7}'::numeric[]))
  • Rows Removed by Filter: 147
3.          

SubPlan (for Seq Scan)

4. 22.665 30.220 ↑ 1.0 1 7,555

Aggregate (cost=0.01..0.02 rows=1 width=0) (actual time=0.003..0.004 rows=1 loops=7,555)

5. 7.555 7.555 ↓ 0.0 0 7,555

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=7,555)

  • One-Time Filter: false
6. 22.653 30.204 ↑ 1.0 1 7,551

Aggregate (cost=0.01..0.02 rows=1 width=0) (actual time=0.003..0.004 rows=1 loops=7,551)

7. 7.551 7.551 ↓ 0.0 0 7,551

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=7,551)

  • One-Time Filter: false