explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qs9u

Settings
# exclusive inclusive rows x rows loops node
1. 20.003 13,315.109 ↓ 21.7 39,182 1

Unique (cost=1,117,848.57..1,117,866.64 rows=1,807 width=165) (actual time=13,288.260..13,315.109 rows=39,182 loops=1)

2. 1,313.368 13,295.106 ↓ 21.7 39,182 1

Sort (cost=1,117,848.57..1,117,853.09 rows=1,807 width=165) (actual time=13,288.258..13,295.106 rows=39,182 loops=1)

  • Sort Key: nmtc.path, tcg.platform_id
  • Sort Method: quicksort Memory: 11,699kB
3. 39.169 11,981.738 ↓ 21.7 39,182 1

Nested Loop (cost=147,429.28..1,117,750.82 rows=1,807 width=165) (actual time=1,572.295..11,981.738 rows=39,182 loops=1)

4. 8.141 11,394.021 ↓ 21.7 39,182 1

Nested Loop (cost=147,428.84..1,102,554.57 rows=1,807 width=12) (actual time=1,572.210..11,394.021 rows=39,182 loops=1)

5. 0.034 0.034 ↑ 1.0 1 1

Index Only Scan using users_pkey on users u (cost=0.41..8.43 rows=1 width=4) (actual time=0.031..0.034 rows=1 loops=1)

  • Index Cond: (id = 10,293)
  • Heap Fetches: 1
6. 10,358.455 11,385.846 ↓ 21.7 39,182 1

Bitmap Heap Scan on test_case_groupings tcg (cost=147,428.43..1,102,528.07 rows=1,807 width=16) (actual time=1,572.176..11,385.846 rows=39,182 loops=1)

  • Recheck Cond: (last_updated_owner_id = 10,293)
  • Filter: (official AND (created_at >= 1,569,392,109) AND (release_id = 0))
  • Rows Removed by Filter: 6,053,880
  • Heap Blocks: exact=403,579
7. 1,027.391 1,027.391 ↓ 1.0 6,093,062 1

Bitmap Index Scan on test_case_groupings_last_updated_owner_id_index (cost=0.00..147,427.98 rows=5,993,522 width=0) (actual time=1,027.391..1,027.391 rows=6,093,062 loops=1)

  • Index Cond: (last_updated_owner_id = 10,293)
8. 548.548 548.548 ↑ 1.0 1 39,182

Index Scan using new_modular_test_cases_id_index on new_modular_test_cases nmtc (cost=0.44..8.40 rows=1 width=161) (actual time=0.014..0.014 rows=1 loops=39,182)

  • Index Cond: (id = tcg.modular_test_case_id)
Planning time : 0.703 ms
Execution time : 13,318.687 ms