explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5g18

Settings
# exclusive inclusive rows x rows loops node
1. 9,058.912 19,731.243 ↑ 4,326.8 5 1

Hash Left Join (cost=217,586.70..4,316,271.91 rows=21,634 width=877) (actual time=9,131.708..19,731.243 rows=5 loops=1)

  • Hash Cond: ((aum.id = ausp.usr_message) AND (aum.usr = ausp.usr))
  • Filter: (((ausp.id IS NOT NULL) OR (NOT aum.deleted)) AND ((LEAST(ausp.stop_date, aum.stop_date) IS NULL) OR (LEAST(ausp.stop_date, aum.stop_date) > '2020-09-09 17:46:38.078018-04'::timestamp with time zone)) AND (COALESCE(ausp.usr, aum.usr) = 3,690,472))
  • Rows Removed by Filter: 13,555,593
2. 7,529.430 7,529.430 ↓ 1.0 12,895,928 1

Seq Scan on usr_message aum (cost=0.00..1,849,305.65 rows=12,851,743 width=777) (actual time=0.122..7,529.430 rows=12,895,928 loops=1)

  • Filter: (NOT deleted)
  • Rows Removed by Filter: 3,866,687
3. 1,996.790 3,142.901 ↑ 1.1 5,670,944 1

Hash (cost=124,647.48..124,647.48 rows=6,195,948 width=44) (actual time=3,142.901..3,142.901 rows=5,670,944 loops=1)

  • Buckets: 8,388,608 Batches: 1 Memory Usage: 464,608kB
4. 1,146.111 1,146.111 ↑ 1.0 6,195,948 1

Seq Scan on usr_standing_penalty ausp (cost=0.00..124,647.48 rows=6,195,948 width=44) (actual time=0.034..1,146.111 rows=6,195,948 loops=1)

Planning time : 15.917 ms
Execution time : 19,756.943 ms