explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z2Vx

Settings
# exclusive inclusive rows x rows loops node
1. 618.300 618.300 ↑ 1.0 182,572 1

CTE Scan on _q1 (cost=11,650.38..15,317.14 rows=183,338 width=304) (actual time=0.016..618.300 rows=182,572 loops=1)

2.          

CTE _q1

3. 173.776 173.776 ↑ 1.0 182,572 1

Seq Scan on port "R" (cost=0.00..11,650.38 rows=183,338 width=481) (actual time=0.011..173.776 rows=182,572 loops=1)

Planning time : 0.118 ms
Execution time : 640.915 ms