explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LGlF

Settings
# exclusive inclusive rows x rows loops node
1. 5.626 232.238 ↓ 159.1 1,114 1

GroupAggregate (cost=302.80..303.15 rows=7 width=92) (actual time=225.625..232.238 rows=1,114 loops=1)

  • Group Key: gl_activity.cid, gl_activity.property_id, gl_activity.gl_account_id
  • Buffers: shared hit=73220 read=13990
2. 6.302 226.612 ↓ 2,718.9 19,032 1

Sort (cost=302.80..302.81 rows=7 width=33) (actual time=225.589..226.612 rows=19,032 loops=1)

  • Sort Key: gl_activity.property_id, gl_activity.gl_account_id
  • Sort Method: quicksort Memory: 2255kB
  • Buffers: shared hit=73220 read=13990
3. 14.549 220.310 ↓ 2,718.9 19,032 1

Nested Loop (cost=1.09..302.70 rows=7 width=33) (actual time=6.987..220.310 rows=19,032 loops=1)

  • Buffers: shared hit=73217 read=13990
4. 3.022 186.729 ↓ 213.8 19,032 1

Nested Loop (cost=0.81..273.10 rows=89 width=33) (actual time=6.971..186.729 rows=19,032 loops=1)

  • Buffers: shared hit=16107 read=13990
5. 6.887 6.887 ↓ 7.0 7 1

Function Scan on load_properties load_prop (cost=0.25..2.00 rows=1 width=4) (actual time=6.873..6.887 rows=7 loops=1)

  • Filter: ((is_disabled = 0) AND (is_test = 0))
  • Buffers: shared hit=2511
6. 176.820 176.820 ↓ 30.6 2,719 7

Index Scan using uk_cached_gl_account_periods_all_ids_post_month on cached_gl_account_periods gl_activity (cost=0.56..268.43 rows=89 width=33) (actual time=0.045..25.260 rows=2,719 loops=7)

  • Index Cond: ((cid = 13576) AND (property_id = load_prop.property_id) AND (gl_book_id = 937) AND (post_month >= '2019-06-01'::date) AND (post_month <= '2019-06-01'::date) AND (is_temporary = false))
  • Filter: (is_temporary IS FALSE)
  • Buffers: shared hit=13596 read=13990
7. 19.032 19.032 ↑ 1.0 1 19,032

Index Scan using idx_gl_accounts_id on gl_accounts ga (cost=0.29..0.33 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=19,032)

  • Index Cond: (id = gl_activity.gl_account_id)
  • Filter: ((is_confidential IS FALSE) AND (cid = 13576))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=57110
Planning time : 1.298 ms
Execution time : 232.445 ms