explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZQRC

Settings
# exclusive inclusive rows x rows loops node
1. 42.464 1,143.160 ↓ 1.6 1,398 1

GroupAggregate (cost=217.38..249.33 rows=852 width=287) (actual time=1,097.364..1,143.160 rows=1,398 loops=1)

  • Group Key: c.con_cl_id, c.con_us_id, g.vgr_id, g.vgr_desc, ai.rui_asset_group_id, ai.rui_asset_id, c.con_id, c.con_name
2. 59.896 1,100.696 ↓ 17.4 14,802 1

Sort (cost=217.38..219.51 rows=852 width=287) (actual time=1,097.082..1,100.696 rows=14,802 loops=1)

  • Sort Key: c.con_cl_id, c.con_us_id, g.vgr_id, g.vgr_desc, ai.rui_asset_group_id, ai.rui_asset_id, c.con_id, c.con_name
  • Sort Method: quicksort Memory: 2465kB
3. 8.312 1,040.800 ↓ 17.4 14,802 1

Hash Right Join (cost=111.49..175.91 rows=852 width=287) (actual time=825.178..1,040.800 rows=14,802 loops=1)

  • Hash Cond: ((cv.cov_cl_id = c.con_cl_id) AND (cv.cov_con_id = c.con_id))
4. 361.794 1,025.709 ↑ 1.0 651 1

Bitmap Heap Scan on tbl_realtime_configuration_var cv (cost=33.33..79.47 rows=651 width=16) (actual time=818.358..1,025.709 rows=651 loops=1)

  • Recheck Cond: (cov_cl_id = 56)
  • Heap Blocks: exact=5
5. 663.915 663.915 ↑ 1.0 651 1

Bitmap Index Scan on configuration_var_unique (cost=0.00..33.16 rows=651 width=0) (actual time=663.915..663.915 rows=651 loops=1)

  • Index Cond: (cov_cl_id = 56)
6. 1.922 6.779 ↓ 5.1 1,695 1

Hash (cost=73.13..73.13 rows=335 width=279) (actual time=6.779..6.779 rows=1,695 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 165kB
7. 2.121 4.857 ↓ 5.1 1,695 1

Hash Right Join (cost=28.92..73.13 rows=335 width=279) (actual time=2.289..4.857 rows=1,695 loops=1)

  • Hash Cond: ((s.ses_cl_id = c.con_cl_id) AND (s.ses_ow = c.con_us_id) AND (s.ses_conf_id = c.con_id) AND (s.ses_asg_id = ai.rui_asset_group_id) AND (s.ses_ass_id = ai.rui_asset_id))
8. 0.516 0.516 ↑ 1.0 619 1

Seq Scan on tbl_realtime_session s (cost=0.00..20.99 rows=619 width=31) (actual time=0.023..0.516 rows=619 loops=1)

  • Filter: (ses_cl_id = 56)
  • Rows Removed by Filter: 179
9. 1.209 2.220 ↓ 4.2 1,398 1

Hash (cost=21.39..21.39 rows=335 width=268) (actual time=2.220..2.220 rows=1,398 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 127kB
10. 0.660 1.011 ↓ 4.2 1,398 1

Hash Left Join (cost=5.09..21.39 rows=335 width=268) (actual time=0.178..1.011 rows=1,398 loops=1)

  • Hash Cond: ((c.con_cl_id = ai.rui_cl_id) AND (c.con_vgr_id = ai.rui_var_group_id))
11. 0.078 0.265 ↑ 1.0 76 1

Hash Left Join (cost=1.29..8.54 rows=76 width=264) (actual time=0.071..0.265 rows=76 loops=1)

  • Hash Cond: (c.con_vgr_id = g.vgr_id)
12. 0.148 0.148 ↑ 1.0 76 1

Seq Scan on tbl_realtime_configuration c (cost=0.00..6.20 rows=76 width=42) (actual time=0.011..0.148 rows=76 loops=1)

  • Filter: (con_cl_id = 56)
  • Rows Removed by Filter: 180
13. 0.016 0.039 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=222) (actual time=0.039..0.039 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.023 0.023 ↑ 1.0 13 1

Seq Scan on tbl_realtime_variable_group g (cost=0.00..1.13 rows=13 width=222) (actual time=0.019..0.023 rows=13 loops=1)

15. 0.029 0.086 ↑ 1.0 54 1

Hash (cost=2.99..2.99 rows=54 width=16) (actual time=0.086..0.086 rows=54 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
16. 0.057 0.057 ↑ 1.0 54 1

Seq Scan on tbl_realtime_asset_info ai (cost=0.00..2.99 rows=54 width=16) (actual time=0.020..0.057 rows=54 loops=1)

  • Filter: (rui_cl_id = 56)
  • Rows Removed by Filter: 25
Planning time : 327.353 ms
Execution time : 1,144.349 ms