explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fc4

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.037 ↑ 6.5 2 1

Sort (cost=137.82..137.86 rows=13 width=222) (actual time=0.037..0.037 rows=2 loops=1)

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

Nested Loop Left Join (cost=0.84..137.58 rows=13 width=222) (actual time=0.019..0.027 rows=2 loops=1)

3. 0.009 0.009 ↑ 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.009 rows=2 loops=1)

  • Index Cond: (client_id = 180688)
4. 0.014 0.014 ↑ 1.0 1 2

Index Scan using cpa_log_cpa_click_id_index on cpa_log log (cost=0.42..8.44 rows=1 width=190) (actual time=0.006..0.007 rows=1 loops=2)

  • Index Cond: (click.id = cpa_click_id)
  • Filter: conversion
  • Rows Removed by Filter: 0