explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X456

Settings
# exclusive inclusive rows x rows loops node
1. 0.085 15,743.068 ↑ 1.0 100 1

Limit (cost=0.00..477.54 rows=100 width=501) (actual time=176.541..15,743.068 rows=100 loops=1)

2. 15,742.983 15,742.983 ↑ 17.7 100 1

Seq Scan on missing_reseller_raw_ids_temp_distinct (cost=0.00..8,452.54 rows=1,770 width=501) (actual time=176.540..15,742.983 rows=100 loops=1)

  • Filter: ((bill_to_reseller_id IS NULL) AND (bill_to_customer_country_id IS NOT NULL) AND (trim_to_null(bill_to_customer_name) IS NOT NULL))