explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JUyQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 8.279 ↑ 1.0 26 1

Limit (cost=1.40..3,428.97 rows=26 width=223) (actual time=7.503..8.279 rows=26 loops=1)

2. 7.561 8.273 ↑ 333.7 26 1

Nested Loop Left Join (cost=1.40..1,143,754.03 rows=8,676 width=223) (actual time=7.501..8.273 rows=26 loops=1)

  • Join Filter: (t."TicketFunctionID" = t0."ID")
  • Rows Removed by Join Filter: 9
3. 0.015 0.686 ↑ 333.7 26 1

Nested Loop Left Join (cost=1.40..1,136,262.60 rows=8,676 width=180) (actual time=0.105..0.686 rows=26 loops=1)

4. 0.024 0.359 ↑ 333.7 26 1

Nested Loop Left Join (cost=0.98..1,121,240.87 rows=8,676 width=180) (actual time=0.061..0.359 rows=26 loops=1)

5. 0.028 0.257 ↑ 333.7 26 1

Nested Loop Left Join (cost=0.70..1,118,627.65 rows=8,676 width=132) (actual time=0.054..0.257 rows=26 loops=1)

6. 0.151 0.151 ↑ 333.7 26 1

Index Scan Backward using "IX_Messages_CreatedDate" on "Messages" m (cost=0.43..1,116,124.19 rows=8,676 width=104) (actual time=0.033..0.151 rows=26 loops=1)

  • Filter: (("DeliveryDate" >= '2020-07-26 00:00:00-04'::timestamp with time zone) AND ("DeliveryDate" < '2020-07-27 00:00:00-04'::timestamp with time zone) AND ("Status" = 1))
  • Rows Removed by Filter: 1
7. 0.078 0.078 ↓ 0.0 0 26

Index Scan using "IX_MessageQueue_MessageID" on "MessageQueue" m0 (cost=0.27..0.29 rows=1 width=44) (actual time=0.003..0.003 rows=0 loops=26)

  • Index Cond: ("MessageID" = m."ID")
8. 0.078 0.078 ↑ 1.0 1 26

Index Scan using "PK_Destinations" on "Destinations" d (cost=0.28..0.30 rows=1 width=64) (actual time=0.003..0.003 rows=1 loops=26)

  • Index Cond: ("ID" = m."SendToDestinationID")
9. 0.312 0.312 ↑ 1.0 1 26

Index Scan using "PK_Tickets" on "Tickets" t (cost=0.42..1.73 rows=1 width=32) (actual time=0.012..0.012 rows=1 loops=26)

  • Index Cond: ("ID" = m."TicketID")
10. 0.018 0.026 ↑ 8.0 1 26

Materialize (cost=0.00..1.12 rows=8 width=26) (actual time=0.001..0.001 rows=1 loops=26)

11. 0.008 0.008 ↑ 2.0 4 1

Seq Scan on "TicketFunctions" t0 (cost=0.00..1.08 rows=8 width=26) (actual time=0.006..0.008 rows=4 loops=1)

Planning time : 4.497 ms
Execution time : 9.455 ms