explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ud9N

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 185.315 ↑ 125.0 4 1

Limit (cost=0.99..144,891.78 rows=500 width=761) (actual time=167.322..185.315 rows=4 loops=1)

2. 6.956 185.313 ↑ 308.2 4 1

Nested Loop (cost=0.99..357,301.67 rows=1,233 width=761) (actual time=167.321..185.313 rows=4 loops=1)

3. 81.842 81.842 ↑ 4.9 19,303 1

Index Scan using index_mirror_data_on_next_execution_and_retry_count on project_mirror_data import_state (cost=0.56..102,274.28 rows=95,083 width=12) (actual time=0.498..81.842 rows=19,303 loops=1)

  • Index Cond: ((next_execution_timestamp <= '2020-03-23 13:43:55.245995+00'::timestamp with time zone) AND (retry_count <= 14))
  • Filter: ((status)::text <> ALL ('{scheduled,started}'::text[]))
  • Rows Removed by Filter: 180
4. 96.515 96.515 ↓ 0.0 0 19,303

Index Scan using projects_pkey on projects (cost=0.43..2.67 rows=1 width=753) (actual time=0.005..0.005 rows=0 loops=19,303)

  • Index Cond: (id = import_state.project_id)
  • Filter: ((NOT archived) AND mirror)
  • Rows Removed by Filter: 1
Planning time : 0.709 ms
Execution time : 185.500 ms