explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sOIj

Settings
# exclusive inclusive rows x rows loops node
1. 50,644.382 125,684.358 ↓ 9.0 534,278,284 1

Nested Loop Left Join (cost=0.71..2,616,777.41 rows=59,337,383 width=58) (actual time=200.964..125,684.358 rows=534,278,284 loops=1)

  • Join Filter: ((_cond_tbl.seller_agent_group_id IS NOT NULL) AND ((_cond_tbl.resource_id < '80000000-0000-4000-8000-000000000000'::uuid) OR (_cond_tbl.resource_id > '80000000-0000-4000-ffff-ffffffffffff'::uuid)))
  • Rows Removed by Join Filter: 132,054
  • JIT:
  • Functions: 9
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 1.871 ms, Inlining 7.554 ms, Optimization 118.124 ms, Emission 73.912 ms, Total 201.461 ms
2. 48.876 48.876 ↑ 1.0 157,876 1

Index Scan using ttix_cond_2x on trade_cond _cond_tbl (cost=0.42..93,992.62 rows=157,876 width=112) (actual time=0.026..48.876 rows=157,876 loops=1)

3. 74,991.100 74,991.100 ↓ 13.5 3,385 157,876

Index Scan using ttix_cond_7 on agent_group_clos_96619e56ad504fe082c007cd159cee93 _s_clos_tbl (cost=0.29..12.21 rows=251 width=38) (actual time=0.004..0.475 rows=3,385 loops=157,876)

  • Index Cond: ((asc_group_id = _cond_tbl.seller_agent_group_id) AND (lower(dt_range) < upper(_cond_tbl.dt_range)) AND (upper(dt_range) > lower(_cond_tbl.dt_range)))
Planning time : 0.621 ms