explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CMqX

Settings
# exclusive inclusive rows x rows loops node
1. 2.465 1,000.441 ↑ 1.0 69,453 1

Gather (cost=1,000.57..794,819.33 rows=70,667 width=33) (actual time=5.540..1,000.441 rows=69,453 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
2. 9.906 997.976 ↑ 1.2 9,922 7 / 7

Nested Loop (cost=0.57..786,752.63 rows=11,778 width=33) (actual time=47.083..997.976 rows=9,922 loops=7)

3. 884.497 884.497 ↑ 7.2 57 7 / 7

Parallel Seq Scan on ig_accounts (cost=0.00..320,678.59 rows=412 width=8) (actual time=6.844..884.497 rows=57 loops=7)

  • Filter: ((id >= 2,000) AND (id <= 2,400))
  • Rows Removed by Filter: 82,051
4. 103.573 103.573 ↑ 7.5 173 401 / 7

Index Scan using index_ig_posts_on_ig_account_id_and_media_type on ig_posts (cost=0.57..1,118.27 rows=1,298 width=29) (actual time=0.033..1.808 rows=173 loops=401)

  • Index Cond: (ig_account_id = ig_accounts.id)
Planning time : 0.490 ms
Execution time : 1,025.811 ms