explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mkAb

Settings
# exclusive inclusive rows x rows loops node
1. 126.077 1,743.686 ↓ 0.0 0 1

Gather (cost=222,654.54..695,752.51 rows=649,966 width=856) (actual time=1,665.891..1,743.686 rows=0 loops=1)

  • Workers Planned: 5
  • Params Evaluated: $0, $1, $2
  • Workers Launched: 5
  • Functions: 174
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 25.093 ms, Inlining 279.071 ms, Optimization 2039.893 ms, Emission 1234.431 ms, Total 3578.488 ms
2.          

Initplan (for Gather)

3. 0.010 0.010 ↑ 2,550.0 1 1

Seq Scan on t_load_from (cost=0.00..35.50 rows=2,550 width=4) (actual time=0.009..0.010 rows=1 loops=1)

4. 0.003 0.003 ↑ 1,360.0 1 1

Seq Scan on apps_flyer_ids (cost=0.00..23.60 rows=1,360 width=32) (actual time=0.003..0.003 rows=1 loops=1)

5. 0.001 0.001 ↑ 1,360.0 1 1

Seq Scan on apps_flyer_ids apps_flyer_ids_1 (cost=0.00..23.60 rows=1,360 width=32) (actual time=0.001..0.001 rows=1 loops=1)

6. 0.000 1,617.595 ↓ 0.0 0 6 / 6

Nested Loop Left Join (cost=221,571.84..629,673.21 rows=129,993 width=856) (actual time=1,617.595..1,617.595 rows=0 loops=6)

7. 144.264 1,617.598 ↓ 0.0 0 6 / 6

Parallel Hash Left Join (cost=221,571.28..524,763.68 rows=129,993 width=709) (actual time=1,617.594..1,617.598 rows=0 loops=6)

  • Hash Cond: (ro.appsflyer_device_id = a.apps_flyer_u_i_d)
8. 1.581 510.697 ↓ 0.0 0 6 / 6

Hash Left Join (cost=0.23..266,223.54 rows=129,993 width=650) (actual time=510.696..510.697 rows=0 loops=6)

  • Hash Cond: (ro.appsflyer_device_id = apps_flyer_id.apps_flyer_id)
  • Filter: ((COALESCE(array_length(($1)::text[], 1), 0) = 0) OR (apps_flyer_id.apps_flyer_id IS NOT NULL))
  • Rows Removed by Filter: 2,966
9. 509.075 509.075 ↑ 44.0 2,966 6 / 6

Parallel Seq Scan on push_report_install ro (cost=0.00..265,733.38 rows=130,643 width=650) (actual time=18.620..509.075 rows=2,966 loops=6)

  • Filter: (((NULLIF(install_time, ''::text))::date >= $0) AND (app_id = ANY ('{com.capital.trading,id1230088754,com.capital.investmate,id1229995329,id1487443266,id1490235342,com.currency.exchange.prod2,id1458917114,id1478283282}'::text[])))
  • Rows Removed by Filter: 470,300
10. 0.005 0.041 ↑ 10.0 1 6 / 6

Hash (cost=0.11..0.11 rows=10 width=32) (actual time=0.040..0.041 rows=1 loops=6)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
11. 0.036 0.036 ↑ 10.0 1 6 / 6

Function Scan on unnest apps_flyer_id (cost=0.01..0.11 rows=10 width=32) (actual time=0.036..0.036 rows=1 loops=6)

12. 106.212 962.637 ↑ 1.2 352,097 6 / 6

Parallel Hash (cost=210,529.69..210,529.69 rows=421,869 width=86) (actual time=962.636..962.637 rows=352,097 loops=6)

  • Buckets: 65,536 Batches: 64 Memory Usage: 4,608kB
13. 856.425 856.425 ↑ 1.2 352,097 6 / 6

Parallel Seq Scan on apps_flyer a (cost=0.00..210,529.69 rows=421,869 width=86) (actual time=592.953..856.425 rows=352,097 loops=6)

14. 0.000 0.000 ↓ 0.0 0 / 6

Index Scan using install_referrer_success_pkey on install_referrer_success r (cost=0.56..0.75 rows=1 width=232) (never executed)

  • Index Cond: (session_id = a.session_id)
  • Filter: (referrer ~~ '%iad-keyword%'::text)
Execution time : 1,750.424 ms