explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xpms

Settings
# exclusive inclusive rows x rows loops node
1. 337.519 1,794.110 ↓ 0.0 0 1

Merge Anti Join (cost=0.85..136,674.96 rows=898,600 width=8) (actual time=1,794.110..1,794.110 rows=0 loops=1)

  • Merge Cond: ((pd.device_id = t.device_id) AND (pd.user_id = t.user_id))
2. 1,039.227 1,039.227 ↑ 1.0 1,198,134 1

Index Only Scan using ix_permissions_device_explicit on permissions_device pd (cost=0.43..57,032.23 rows=1,198,134 width=8) (actual time=0.127..1,039.227 rows=1,198,134 loops=1)

  • Heap Fetches: 1198134
3. 417.364 417.364 ↑ 1.0 1,266,047 1

Index Only Scan using ix_permissions_device_explicit_user_device on tmp_user_device t (cost=0.43..60,267.15 rows=1,266,048 width=8) (actual time=0.240..417.364 rows=1,266,047 loops=1)

  • Heap Fetches: 1266047