explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fFuL

Settings
# exclusive inclusive rows x rows loops node
1. 43,677.102 451,578.326 ↑ 1.0 1 1

Aggregate (cost=6,181,751.83..6,181,751.83 rows=1 width=8) (actual time=451,578.326..451,578.326 rows=1 loops=1)

2. 407,901.224 407,901.224 ↑ 1.0 202,543,866 1

Seq Scan on core_test (cost=0.00..5,653,397.26 rows=211,341,826 width=0) (actual time=0.039..407,901.224 rows=202,543,866 loops=1)

Planning time : 0.082 ms
Execution time : 451,578.827 ms