explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wEMi

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 59.784 ↑ 6.5 2 1

Sort (cost=10,637.81..10,637.84 rows=13 width=225) (actual time=59.784..59.784 rows=2 loops=1)

  • Sort Key: click.id DESC
  • Sort Method: quicksort Memory: 25kB
2. 14.198 59.767 ↑ 6.5 2 1

Hash Right Join (cost=27.93..10,637.57 rows=13 width=225) (actual time=41.296..59.767 rows=2 loops=1)

  • Hash Cond: (log.cpa_click_id = click.id)
3. 45.555 45.555 ↓ 1.0 64,908 1

Seq Scan on cpa_log log (cost=0.00..10,440.83 rows=64,310 width=193) (actual time=0.007..45.555 rows=64,908 loops=1)

  • Filter: conversion
  • Rows Removed by Filter: 155494
4. 0.003 0.014 ↑ 6.5 2 1

Hash (cost=27.77..27.77 rows=13 width=32) (actual time=0.013..0.014 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.011 0.011 ↑ 6.5 2 1

Index Scan using cpa_click_client_id_idx_partial on cpa_click click (cost=0.42..27.77 rows=13 width=32) (actual time=0.008..0.011 rows=2 loops=1)

  • Index Cond: (client_id = 180688)