explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pbww

Settings
# exclusive inclusive rows x rows loops node
1. 511.210 1,061.102 ↓ 1.1 1,279,815 1

Unique (cost=0.43..89,335.13 rows=1,175,211 width=4) (actual time=0.027..1,061.102 rows=1,279,815 loops=1)

2. 549.892 549.892 ↓ 1.0 2,963,729 1

Index Only Scan using crowd_translator_lang_pair_user_id_key on crowd_translator_lang_pair (cost=0.43..81,948.87 rows=2,954,507 width=4) (actual time=0.026..549.892 rows=2,963,729 loops=1)

  • Heap Fetches: 485,989