explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TX13

Settings
# exclusive inclusive rows x rows loops node
1. 0.745 1,711.064 ↑ 1.0 1 1

Aggregate (cost=137,001.61..137,001.62 rows=1 width=0) (actual time=1,711.064..1,711.064 rows=1 loops=1)

2. 342.483 1,710.319 ↓ 3,180.0 3,180 1

Merge Left Join (cost=0.85..137,001.61 rows=1 width=0) (actual time=974.876..1,710.319 rows=3,180 loops=1)

  • Merge Cond: (c.id = t.cellphone_id)
  • Filter: (t.id IS NULL)
  • Rows Removed by Filter: 544500
3. 492.384 492.384 ↑ 1.0 544,920 1

Index Scan using cellphones_pkey on cellphones c (cost=0.42..68,869.46 rows=554,479 width=16) (actual time=0.020..492.384 rows=544,920 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 87670
4. 875.452 875.452 ↑ 6.4 544,993 1

Index Scan using transactions_cellphone_id_index on transactions t (cost=0.43..402,742.21 rows=3,496,757 width=12) (actual time=0.004..875.452 rows=544,993 loops=1)