explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E2QZ : Optimization for: conversion_analytics; plan #iDH1

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.038 759.515 ↑ 1.0 1,000 1

Limit (cost=0.01..470.09 rows=1,000 width=688) (actual time=76.647..759.515 rows=1,000 loops=1)

  • Buffers: shared hit=265 read=134
  • I/O Timings: read=510.360
2. 234.014 758.477 ↑ 5,978.6 1,000 1

Nested Loop (cost=0.01..2,810,443.20 rows=5,978,600 width=688) (actual time=76.645..758.477 rows=1,000 loops=1)

  • Buffers: shared hit=265 read=134
  • I/O Timings: read=510.360
3. 0.529 400.783 ↑ 77.3 773 1

Append (cost=0.00..60,287.20 rows=59,786 width=80) (actual time=76.193..400.783 rows=773 loops=1)

  • Buffers: shared hit=36 read=127
  • I/O Timings: read=397.567
4. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on conversion c (cost=0.00..0.00 rows=1 width=80) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
5. 400.230 400.230 ↑ 46.3 773 1

Index Scan using route_conversion_1549144800_endtime_idx on conversion_1549144800 c_1 (cost=0.43..35,947.75 rows=35,826 width=80) (actual time=76.167..400.230 rows=773 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=36 read=127
  • I/O Timings: read=397.567
6. 0.000 0.000 ↓ 0.0 0

Index Scan using route_conversion_1549231200_endtime_idx on conversion_1549231200 c_2 (cost=0.43..24,040.51 rows=23,959 width=80) (never executed)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
7. 123.680 123.680 ↑ 100.0 1 773

Function Scan on jsonb_each esme (cost=0.01..1.00 rows=100 width=64) (actual time=0.159..0.160 rows=1 loops=773)

  • Buffers: shared hit=37 read=7
  • I/O Timings: read=112.793