explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QUvR

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 108,348.873 ↑ 1.0 50 1

Limit (cost=691,952.94..691,953.06 rows=50 width=291) (actual time=108,348.850..108,348.873 rows=50 loops=1)

2. 2,561.759 108,348.865 ↑ 28,434.0 50 1

Sort (cost=691,952.94..695,507.19 rows=1,421,702 width=291) (actual time=108,348.847..108,348.865 rows=50 loops=1)

  • Sort Key: a_ogrn, a_ouid
  • Sort Method: top-N heapsort Memory: 45kB
3. 105,787.106 105,787.106 ↑ 1.0 1,421,702 1

Seq Scan on fns_egrip_egrul fnsegripegrul_fns_egrip_egrul (cost=0.00..644,725.02 rows=1,421,702 width=291) (actual time=0.034..105,787.106 rows=1,421,702 loops=1)

Planning time : 0.193 ms
Execution time : 108,348.938 ms