explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5GWb

Settings
# exclusive inclusive rows x rows loops node
1. 2,338.914 2,352.956 ↓ 278.0 834 1

Update on rsstuff_rsrecording r (cost=0.99..605.14 rows=3 width=2,097) (actual time=8.374..2,352.956 rows=834 loops=1)

2. 4.036 14.042 ↓ 278.0 834 1

Nested Loop (cost=0.99..605.14 rows=3 width=2,097) (actual time=0.249..14.042 rows=834 loops=1)

3. 0.107 0.107 ↑ 1.0 1 1

Index Scan using content_asset_schedule_guid_key on content_asset a (cost=0.43..2.45 rows=1 width=34) (actual time=0.104..0.107 rows=1 loops=1)

  • Index Cond: (schedule_guid = 'f44d62d2-3d15-46e2-bfc2-f7950c49affe'::uuid)
4. 9.899 9.899 ↓ 5.1 834 1

Index Scan using rsstuff_rsrecording_51c6d5db on rsstuff_rsrecording r (cost=0.56..600.97 rows=164 width=1,138) (actual time=0.126..9.899 rows=834 loops=1)

  • Index Cond: (asset_id = a.id)
  • Filter: ((date_bound IS NULL) AND (state <> ALL ('{2,4}'::integer[])) AND (rec_start <= a.start))
  • Rows Removed by Filter: 9
Planning time : 0.718 ms
Execution time : 2,353.552 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
update_user_recspace_update_trigger 14.625 ms 834 0.018 ms