explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OW2

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 358.747 1,470.410 ↑ 1.0 167,518 1

Merge Join (cost=134,983.09..141,462.98 rows=167,820 width=110) (actual time=1,240.655..1,470.410 rows=167,518 loops=1)

  • Merge Cond: (nd.notification_id = na.notification_id)
2. 891.856 891.856 ↑ 1.0 2,687,789 1

Index Scan using details_pkey on details nd (cost=0.43..108,842.46 rows=2,694,792 width=74) (actual time=0.025..891.856 rows=2,687,789 loops=1)

3. 39.796 219.807 ↑ 1.0 167,518 1

Materialize (cost=23,316.61..24,155.71 rows=167,820 width=36) (actual time=155.281..219.807 rows=167,518 loops=1)

4. 126.685 180.011 ↑ 1.0 167,518 1

Sort (cost=23,316.61..23,736.16 rows=167,820 width=36) (actual time=155.273..180.011 rows=167,518 loops=1)

  • Sort Key: na.notification_id
  • Sort Method: external sort Disk: 8,184kB
5. 53.326 53.326 ↑ 1.0 167,518 1

Seq Scan on active na (cost=0.00..4,160.73 rows=167,820 width=36) (actual time=0.087..53.326 rows=167,518 loops=1)

  • Filter: (trigger_date <= now())
  • Rows Removed by Filter: 2,417