explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YHMl

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 216.938 ↓ 1.4 26 1

Append (cost=5,463.57..10,947.47 rows=19 width=171) (actual time=107.173..216.938 rows=26 loops=1)

2. 0.009 107.178 ↓ 2.5 5 1

Hash Join (cost=5,463.57..5,469.31 rows=2 width=171) (actual time=107.172..107.178 rows=5 loops=1)

  • Hash Cond: ((a.rep_attr_08)::text = (ra.attr_code)::text)
3. 14.386 107.122 ↑ 38.0 5 1

HashAggregate (cost=5,456.35..5,459.67 rows=190 width=66) (actual time=107.119..107.122 rows=5 loops=1)

  • Group Key: to_char((b.book_date)::timestamp with time zone, 'yyyy/mm'::text), a.rep_attr_08
4. 28.399 92.736 ↓ 2.4 22,035 1

Hash Join (cost=1,619.62..5,364.10 rows=9,225 width=86) (actual time=19.169..92.736 rows=22,035 loops=1)

  • Hash Cond: (gl.batch_id = b.batch_id)
5. 32.863 45.511 ↓ 2.4 22,035 1

Hash Join (cost=3.46..3,677.56 rows=9,239 width=66) (actual time=0.059..45.511 rows=22,035 loops=1)

  • Hash Cond: (gl.acc_id = a.acc_id)
6. 12.612 12.612 ↓ 1.0 138,607 1

Seq Scan on fin_gl gl (cost=0.00..3,298.88 rows=138,588 width=73) (actual time=0.011..12.612 rows=138,607 loops=1)

7. 0.008 0.036 ↑ 1.0 9 1

Hash (cost=3.35..3.35 rows=9 width=11) (actual time=0.036..0.036 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.028 0.028 ↑ 1.0 9 1

Seq Scan on fin_acc_conf_applied a (cost=0.00..3.35 rows=9 width=11) (actual time=0.025..0.028 rows=9 loops=1)

  • Filter: (rep_attr_08 IS NOT NULL)
  • Rows Removed by Filter: 127
9. 9.991 18.826 ↑ 1.0 38,516 1

Hash (cost=1,134.68..1,134.68 rows=38,518 width=16) (actual time=18.826..18.826 rows=38,516 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2356kB
10. 8.835 8.835 ↑ 1.0 38,516 1

Seq Scan on fin_gl_book b (cost=0.00..1,134.68 rows=38,518 width=16) (actual time=0.013..8.835 rows=38,516 loops=1)

  • Filter: ((book_date >= '2018-01-01'::date) AND (book_date <= '2018-12-31'::date))
  • Rows Removed by Filter: 1
11. 0.006 0.047 ↑ 1.0 2 1

Hash (cost=7.20..7.20 rows=2 width=75) (actual time=0.047..0.047 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
12. 0.041 0.041 ↑ 1.0 2 1

Seq Scan on fin_report_attr ra (cost=0.00..7.20 rows=2 width=75) (actual time=0.032..0.041 rows=2 loops=1)

  • Filter: ((report_code)::text = 'FR08'::text)
  • Rows Removed by Filter: 174
13. 0.075 109.757 ↓ 1.2 21 1

Hash Join (cost=5,463.64..5,477.97 rows=17 width=171) (actual time=109.722..109.757 rows=21 loops=1)

  • Hash Cond: ((a_1.rep_attr_09)::text = (ra_1.attr_code)::text)
14. 14.886 109.622 ↑ 22.6 21 1

HashAggregate (cost=5,456.35..5,464.66 rows=475 width=66) (actual time=109.600..109.622 rows=21 loops=1)

  • Group Key: to_char((b_1.book_date)::timestamp with time zone, 'yyyy/mm'::text), a_1.rep_attr_09
15. 29.724 94.736 ↓ 2.5 22,832 1

Hash Join (cost=1,619.62..5,364.10 rows=9,225 width=86) (actual time=19.601..94.736 rows=22,832 loops=1)

  • Hash Cond: (gl_1.batch_id = b_1.batch_id)
16. 33.115 45.761 ↓ 2.5 22,832 1

Hash Join (cost=3.46..3,677.56 rows=9,239 width=66) (actual time=0.066..45.761 rows=22,832 loops=1)

  • Hash Cond: (gl_1.acc_id = a_1.acc_id)
17. 12.606 12.606 ↓ 1.0 138,607 1

Seq Scan on fin_gl gl_1 (cost=0.00..3,298.88 rows=138,588 width=73) (actual time=0.013..12.606 rows=138,607 loops=1)

18. 0.007 0.040 ↑ 1.0 9 1

Hash (cost=3.35..3.35 rows=9 width=11) (actual time=0.040..0.040 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.033 0.033 ↑ 1.0 9 1

Seq Scan on fin_acc_conf_applied a_1 (cost=0.00..3.35 rows=9 width=11) (actual time=0.029..0.033 rows=9 loops=1)

  • Filter: (rep_attr_09 IS NOT NULL)
  • Rows Removed by Filter: 127
20. 10.375 19.251 ↑ 1.0 38,516 1

Hash (cost=1,134.68..1,134.68 rows=38,518 width=16) (actual time=19.251..19.251 rows=38,516 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2356kB
21. 8.876 8.876 ↑ 1.0 38,516 1

Seq Scan on fin_gl_book b_1 (cost=0.00..1,134.68 rows=38,518 width=16) (actual time=0.016..8.876 rows=38,516 loops=1)

  • Filter: ((book_date >= '2018-01-01'::date) AND (book_date <= '2018-12-31'::date))
  • Rows Removed by Filter: 1
22. 0.008 0.060 ↑ 1.0 7 1

Hash (cost=7.20..7.20 rows=7 width=75) (actual time=0.060..0.060 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.052 0.052 ↑ 1.0 7 1

Seq Scan on fin_report_attr ra_1 (cost=0.00..7.20 rows=7 width=75) (actual time=0.043..0.052 rows=7 loops=1)

  • Filter: ((report_code)::text = 'FR09'::text)
  • Rows Removed by Filter: 169