explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FujY

Settings
# exclusive inclusive rows x rows loops node
1. 0.149 7,876.834 ↑ 1.0 100 1

Limit (cost=0.00..447.33 rows=100 width=1,810) (actual time=4.109..7,876.834 rows=100 loops=1)

2. 1,770.621 7,876.685 ↑ 164.7 100 1

Nested Loop (cost=0.00..73,666.96 rows=16,468 width=1,810) (actual time=4.108..7,876.685 rows=100 loops=1)

3. 4,083.964 4,083.964 ↑ 164.7 100 1

Index Scan Backward using ix_dmaini_l_messaggi_data_ricezione on dmaini_l_messaggi a (cost=0.00..12,315.04 rows=16,468 width=444) (actual time=0.070..4,083.964 rows=100 loops=1)

  • Index Cond: (data_ricezione >= '2020-02-01 00:00:00'::timestamp without time zone)
  • Filter: ((chiamante)::text = 'INI'::text)
  • Rows Removed by Filter: 6108
4. 2,022.100 2,022.100 ↑ 1.0 1 100

Index Scan using dmaini_l_xml_messaggi_wso2_id_key on dmaini_l_xml_messaggi b (cost=0.00..3.69 rows=1 width=1,366) (actual time=16.957..20.221 rows=1 loops=100)

  • Index Cond: ((wso2_id)::text = (a.wso2_id)::text)
Total runtime : 7,877.035 ms