explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y2qb

Settings
# exclusive inclusive rows x rows loops node
1. 1,730.285 97,295.367 ↑ 3,485,820,137,312.0 1 1

Merge Right Join (cost=25,530,183.43..52,333,687,840.03 rows=3,485,820,137,312 width=164) (actual time=97,295.362..97,295.367 rows=1 loops=1)

  • Merge Cond: (m.mfc = v.mfc)
2. 95,535.149 95,535.149 ↑ 1.4 5,606,401 1

Index Scan using vins_mfc_mfc_idx on vins_mfc m (cost=0.43..20,618,313.42 rows=8,021,666 width=36) (actual time=0.066..95,535.149 rows=5,606,401 loops=1)

3. 0.005 29.933 ↑ 86,910,129.0 1 1

Materialize (cost=25,530,182.99..25,964,733.64 rows=86,910,129 width=136) (actual time=29.932..29.933 rows=1 loops=1)

4. 0.012 29.928 ↑ 86,910,129.0 1 1

Sort (cost=25,530,182.99..25,747,458.32 rows=86,910,129 width=136) (actual time=29.927..29.928 rows=1 loops=1)

  • Sort Key: v.mfc
  • Sort Method: quicksort Memory: 25kB
5. 2.501 29.916 ↑ 86,910,129.0 1 1

Merge Right Join (cost=882,680.50..2,187,521.71 rows=86,910,129 width=136) (actual time=29.914..29.916 rows=1 loops=1)

  • Merge Cond: (d.hex = v.date)
6. 14.991 27.273 ↑ 2.4 18,524 1

Sort (cost=4,291.00..4,403.71 rows=45,085 width=36) (actual time=26.081..27.273 rows=18,524 loops=1)

  • Sort Key: d.hex
  • Sort Method: quicksort Memory: 4608kB
7. 12.282 12.282 ↓ 1.5 65,535 1

Seq Scan on dates_decode d (cost=0.00..805.85 rows=45,085 width=36) (actual time=0.015..12.282 rows=65,535 loops=1)

8. 0.018 0.142 ↑ 385,539.0 1 1

Materialize (cost=878,389.50..880,317.20 rows=385,539 width=104) (actual time=0.142..0.142 rows=1 loops=1)

9. 0.017 0.124 ↑ 385,539.0 1 1

Sort (cost=878,389.50..879,353.35 rows=385,539 width=104) (actual time=0.124..0.124 rows=1 loops=1)

  • Sort Key: v.date
  • Sort Method: quicksort Memory: 25kB
10. 0.005 0.107 ↑ 385,539.0 1 1

Bitmap Heap Scan on vins v (cost=10,636.49..821,530.70 rows=385,539 width=104) (actual time=0.107..0.107 rows=1 loops=1)

  • Recheck Cond: (vin = 'VS6AXXWPFATR21154'::text)
  • Heap Blocks: exact=1
11. 0.102 0.102 ↑ 385,539.0 1 1

Bitmap Index Scan on vins_vin_idx (cost=0.00..10,540.11 rows=385,539 width=0) (actual time=0.102..0.102 rows=1 loops=1)

  • Index Cond: (vin = 'VS6AXXWPFATR21154'::text)