explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X5QO

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,536.582 ↓ 0.0 0 1

Nested Loop (cost=4.16..463,238.72 rows=42 width=901) (actual time=4,536.582..4,536.582 rows=0 loops=1)

2. 0.001 4,536.582 ↓ 0.0 0 1

Nested Loop (cost=4.07..463,180.71 rows=42 width=767) (actual time=4,536.582..4,536.582 rows=0 loops=1)

3. 386.726 4,536.581 ↓ 0.0 0 1

Hash Join (cost=3.99..463,093.37 rows=63 width=574) (actual time=4,536.581..4,536.581 rows=0 loops=1)

  • Hash Cond: (rs.recsi_matching_id = matching_results.id)
4. 4,149.758 4,149.758 ↑ 1.0 5,625,295 1

Seq Scan on reconciliation_skel rs (cost=0.00..458,861.04 rows=5,637,365 width=566) (actual time=0.012..4,149.758 rows=5,625,295 loops=1)

  • Filter: is_active
  • Rows Removed by Filter: 3718249
5. 0.017 0.097 ↑ 1.0 100 1

Hash (cost=3.44..3.44 rows=100 width=8) (actual time=0.097..0.097 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
6. 0.030 0.080 ↑ 1.0 100 1

HashAggregate (cost=2.94..3.44 rows=100 width=8) (actual time=0.071..0.080 rows=100 loops=1)

  • Group Key: matching_results.id
7. 0.005 0.050 ↑ 1.0 100 1

Limit (cost=0.09..2.39 rows=100 width=8) (actual time=0.008..0.050 rows=100 loops=1)

8. 0.045 0.045 ↑ 96,937.6 100 1

Index Only Scan Backward using matching_results_pkey on matching_results (cost=0.09..222,937.84 rows=9,693,759 width=8) (actual time=0.008..0.045 rows=100 loops=1)

  • Heap Fetches: 100
9. 0.000 0.000 ↓ 0.0 0

Index Scan using matching_results_pkey on matching_results mr (cost=0.09..1.38 rows=1 width=201) (never executed)

  • Index Cond: (id = rs.recsi_matching_id)
  • Filter: (status <> rs.status_id)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using reconciliation_info_pkey on reconciliation_info ri (cost=0.09..1.38 rows=1 width=134) (never executed)

  • Index Cond: (id = rs.id)