explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hIFo

Settings
# exclusive inclusive rows x rows loops node
1. 456.134 1,487.649 ↓ 1.0 177,158 1

Merge Join (cost=135,239.89..141,791.47 rows=171,004 width=110) (actual time=1,186.889..1,487.649 rows=177,158 loops=1)

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

Index Scan using details_pkey on details nd (cost=0.43..108,685.70 rows=2,690,008 width=74) (actual time=0.014..804.518 rows=2,687,015 loops=1)

3. 21.037 226.997 ↓ 1.0 177,158 1

Materialize (cost=23,735.69..24,590.71 rows=171,004 width=36) (actual time=179.838..226.997 rows=177,158 loops=1)

4. 140.860 205.960 ↓ 1.0 177,158 1

Sort (cost=23,735.69..24,163.20 rows=171,004 width=36) (actual time=179.833..205.960 rows=177,158 loops=1)

  • Sort Key: na.notification_id
  • Sort Method: external sort Disk: 8,672kB
5. 65.100 65.100 ↓ 1.0 177,158 1

Seq Scan on active na (cost=0.00..4,196.31 rows=171,004 width=36) (actual time=0.191..65.100 rows=177,158 loops=1)

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