explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JPX8

Settings
# exclusive inclusive rows x rows loops node
1. 8.313 4,374.046 ↑ 1.0 1 1

Aggregate (cost=300,809.83..300,809.83 rows=1 width=8) (actual time=4,374.046..4,374.046 rows=1 loops=1)

2. 78.646 4,365.733 ↓ 34.1 124,395 1

Nested Loop (cost=0.14..300,808.00 rows=3,643 width=8) (actual time=3,551.772..4,365.733 rows=124,395 loops=1)

3. 1,126.126 4,033.197 ↓ 34.7 126,945 1

Nested Loop (cost=0.06..293,607.70 rows=3,655 width=8) (actual time=314.465..4,033.197 rows=126,945 loops=1)

  • Join Filter: (r2_.id = r0_.reconciliation_id)
  • Rows Removed by Join Filter: 16037343
4. 0.069 1.007 ↓ 1.8 126 1

Nested Loop (cost=0.06..37.88 rows=72 width=8) (actual time=0.029..1.007 rows=126 loops=1)

5. 0.303 0.303 ↓ 1.0 127 1

Index Scan using reconciliation_pkey on reconciliation r2_ (cost=0.03..21.63 rows=125 width=16) (actual time=0.013..0.303 rows=127 loops=1)

  • Filter: sent_to_processing
6. 0.635 0.635 ↑ 1.0 1 127

Index Scan using tasks_pkey on tasks t3_ (cost=0.03..0.13 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=127)

  • Index Cond: (id = r2_.task_id)
  • Filter: ((status = 3) AND (current_state = 6) AND (next_state_num = 6))
  • Rows Removed by Filter: 0
7. 675.854 2,906.064 ↓ 20.2 128,288 126

Materialize (cost=0.00..290,823.33 rows=6,365 width=16) (actual time=0.001..23.064 rows=128,288 loops=126)

8. 2,230.210 2,230.210 ↓ 20.2 128,288 1

Seq Scan on reconciliation_skel r0_ (cost=0.00..290,816.96 rows=6,365 width=16) (actual time=0.056..2,230.210 rows=128,288 loops=1)

  • Filter: ((NOT sent_to_processing) AND (mod(id, '10'::bigint) = 0))
  • Rows Removed by Filter: 5668083
9. 253.890 253.890 ↑ 1.0 1 126,945

Index Only Scan using reconciliation_info_pkey on reconciliation_info r1_ (cost=0.09..1.96 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=126,945)

  • Index Cond: (id = r0_.id)
  • Heap Fetches: 124395