explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b81E

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 891.295 ↑ 1.0 1 1

Nested Loop (cost=0.00..90,546.38 rows=1 width=47) (actual time=450.277..891.295 rows=1 loops=1)

  • Join Filter: (msisdn_list.segment_id = segment.id)
  • Rows Removed by Join Filter: 20
2. 891.263 891.263 ↑ 1.0 1 1

Seq Scan on msisdn_list (cost=0.00..90,544.91 rows=1 width=21) (actual time=450.246..891.263 rows=1 loops=1)

  • Filter: ((NOT deleted) AND (msisdn = '56930000447'::text) AND ((date_in IS NULL) OR (date_in < now())) AND ((date_out IS NULL) OR (date_out > now())))
  • Rows Removed by Filter: 2822632
3. 0.018 0.018 ↑ 1.0 21 1

Seq Scan on segment (cost=0.00..1.21 rows=21 width=30) (actual time=0.016..0.018 rows=21 loops=1)

Planning time : 0.503 ms
Execution time : 891.359 ms