explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ek1M

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 670.010 ↑ 1.0 10 1

Limit (cost=2,279,062.00..2,279,062.02 rows=10 width=239) (actual time=670.007..670.010 rows=10 loops=1)

2. 328.670 669.995 ↑ 1,649.0 580 1

Sort (cost=2,279,060.57..2,281,451.63 rows=956,424 width=239) (actual time=669.903..669.995 rows=580 loops=1)

  • Sort Key: "time" DESC
  • Sort Method: top-N heapsort Memory: 724kB
3. 341.325 341.325 ↑ 1.0 941,791 1

Index Scan using index_on_commits_code_set_id_position on commits (cost=0.57..2,230,379.02 rows=956,424 width=239) (actual time=0.026..341.325 rows=941,791 loops=1)

  • Index Cond: (code_set_id = ANY ('{560326,840483}'::integer[]))
Planning time : 0.232 ms
Execution time : 670.057 ms