explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uF2j

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 58.067 ↑ 37.3 18 1

Sort (cost=6,608.88..6,610.55 rows=671 width=140) (actual time=58.066..58.067 rows=18 loops=1)

  • Sort Key: outage_changes_view_v2.changed_date_time
  • Sort Method: quicksort Memory: 27kB
2. 0.019 58.052 ↑ 37.3 18 1

Sort (cost=6,568.98..6,570.66 rows=671 width=140) (actual time=58.048..58.052 rows=18 loops=1)

  • Sort Key: outage_changes_view_v2.changed_date_time DESC
  • Sort Method: quicksort Memory: 27kB
3. 9.011 58.033 ↑ 37.3 18 1

Subquery Scan on outage_changes_view_v2 (cost=0.00..6,537.48 rows=671 width=140) (actual time=9.207..58.033 rows=18 loops=1)

  • Filter: (outage_changes_view_v2.outage_id = '15905'::text)
  • Rows Removed by Filter: 133,693
4. 7.883 49.022 ↑ 1.0 133,711 1

Append (cost=0.00..4,860.70 rows=134,142 width=140) (actual time=0.019..49.022 rows=133,711 loops=1)

5. 7.703 7.703 ↑ 1.0 11,656 1

Seq Scan on outages_changes_v2 (cost=0.00..740.26 rows=11,739 width=125) (actual time=0.019..7.703 rows=11,656 loops=1)

6. 13.269 33.436 ↑ 1.0 122,055 1

Subquery Scan on *SELECT* 2 (cost=0.00..4,003.06 rows=122,403 width=102) (actual time=0.007..33.436 rows=122,055 loops=1)

7. 20.167 20.167 ↑ 1.0 122,055 1

Seq Scan on transformer_outages_changes (cost=0.00..2,779.03 rows=122,403 width=68) (actual time=0.005..20.167 rows=122,055 loops=1)

Planning time : 0.206 ms
Execution time : 58.125 ms