explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xn5v

Settings
# exclusive inclusive rows x rows loops node
1. 98.228 279.693 ↓ 96.0 255,401 1

Nested Loop (cost=1,073.14..15,001.98 rows=2,661 width=4) (actual time=5.286..279.693 rows=255,401 loops=1)

2. 0.025 0.025 ↓ 8.0 8 1

Index Scan using xact_templatelanguage_template_id_58a8d1a4 on xact_templatelanguage u0 (cost=0.14..8.16 rows=1 width=4) (actual time=0.014..0.025 rows=8 loops=1)

  • Index Cond: (template_id = 3)
  • Filter: (state <> 2)
3. 157.168 181.440 ↓ 6.3 31,925 8

Bitmap Heap Scan on xact_message (cost=1,073.00..14,943.13 rows=5,069 width=8) (actual time=3.937..22.680 rows=31,925 loops=8)

  • Recheck Cond: (templatelanguage_id = u0.id)
  • Filter: ((state <> 2) AND (state <> ALL ('{5,6}'::integer[])) AND ((state = 4) OR (state = 3) OR ((state = 1) AND (send_on < '2019-04-09 08:19:25.89357+00'::timestamp with time zone))))
  • Rows Removed by Filter: 35562
  • Heap Blocks: exact=20577
4. 24.272 24.272 ↓ 2.4 67,487 8

Bitmap Index Scan on xact_message_templatelanguage_id_c4cf5d56 (cost=0.00..1,071.73 rows=27,641 width=0) (actual time=3.034..3.034 rows=67,487 loops=8)

  • Index Cond: (templatelanguage_id = u0.id)