explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tp6l

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 14,050.138 ↑ 1.0 24 1

Limit (cost=45,718.23..1,143,088.30 rows=24 width=228) (actual time=533.423..14,050.138 rows=24 loops=1)

2. 0.169 14,050.127 ↑ 3,172.3 24 1

Nested Loop (cost=45,718.23..3,481,269,392.80 rows=76,136 width=228) (actual time=533.422..14,050.127 rows=24 loops=1)

3. 0.114 14,049.118 ↑ 3,172.3 24 1

Nested Loop (cost=45,717.81..3,480,777,758.93 rows=76,136 width=229) (actual time=533.375..14,049.118 rows=24 loops=1)

4. 0.086 0.086 ↑ 2,928.3 26 1

Seq Scan on salestransaction aa (cost=0.00..5,227.15 rows=76,136 width=160) (actual time=0.006..0.086 rows=26 loops=1)

  • Filter: ((start_action_date > '2019-08-31 21:00:00'::timestamp without time zone) AND (start_action_date < '2019-11-29 20:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 8
5. 0.156 14,048.918 ↑ 1.0 1 26

Limit (cost=45,717.81..45,717.81 rows=1 width=109) (actual time=540.343..540.343 rows=1 loops=26)

6. 0.546 14,048.762 ↑ 6.0 1 26

Sort (cost=45,717.81..45,717.82 rows=6 width=109) (actual time=540.337..540.337 rows=1 loops=26)

  • Sort Key: videoexporthistory_v2.actiontime
  • Sort Method: top-N heapsort Memory: 25kB
7. 0.962 14,048.216 ↑ 2.0 3 26

Append (cost=0.00..45,717.78 rows=6 width=109) (actual time=168.453..540.316 rows=3 loops=26)

8. 0.026 0.026 ↓ 0.0 0 26

Seq Scan on videoexporthistory_v2 (cost=0.00..0.00 rows=1 width=108) (actual time=0.001..0.001 rows=0 loops=26)

  • Filter: ((actiontime > '2019-08-31 21:00:00'::timestamp without time zone) AND (actiontime < '2019-11-29 20:59:59'::timestamp without time zone) AND (aa.id = relatedactionid))
9. 14,047.228 14,047.228 ↑ 1.7 3 26

Index Scan using videoexporthistory_v2_0_actiontime_ix on videoexporthistory_v2_0 (cost=0.42..45,717.78 rows=5 width=109) (actual time=168.417..540.278 rows=3 loops=26)

  • Index Cond: ((actiontime > '2019-08-31 21:00:00'::timestamp without time zone) AND (actiontime < '2019-11-29 20:59:59'::timestamp without time zone))
  • Filter: (aa.id = relatedactionid)
  • Rows Removed by Filter: 574080
10. 0.096 0.840 ↑ 1.0 1 24

Limit (cost=0.42..6.44 rows=1 width=49) (actual time=0.035..0.035 rows=1 loops=24)

11. 0.744 0.744 ↑ 2.0 1 24

Index Scan using salestransactionpayment_salestransaction_id_ix on salestransactionpayment (cost=0.42..12.45 rows=2 width=49) (actual time=0.031..0.031 rows=1 loops=24)

  • Index Cond: (aa.id = salestransaction_id)
Planning time : 0.684 ms
Execution time : 14,050.296 ms