explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3qE8 : Optimization for: conversion_interval; plan #JRGu

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 1.331 163.496 ↑ 1.0 1 1

Aggregate (cost=110.05..110.06 rows=1 width=16) (actual time=163.495..163.496 rows=1 loops=1)

  • Buffers: shared hit=587 read=36
  • I/O Timings: read=128.528
2. 1.562 162.165 ↑ 1.0 3,000 1

Limit (cost=0.01..65.05 rows=3,000 width=688) (actual time=56.583..162.165 rows=3,000 loops=1)

  • Buffers: shared hit=587 read=36
  • I/O Timings: read=128.528
3. 3.689 160.603 ↑ 24,771.1 3,000 1

Nested Loop (cost=0.01..1,611,332.68 rows=74,313,400 width=688) (actual time=56.581..160.603 rows=3,000 loops=1)

  • Buffers: shared hit=587 read=36
  • I/O Timings: read=128.528
4. 1.177 20.801 ↑ 322.1 2,307 1

Append (cost=0.00..125,064.67 rows=743,134 width=1,048) (actual time=15.524..20.801 rows=2,307 loops=1)

  • Buffers: shared hit=470 read=10
  • I/O Timings: read=16.795
5. 0.028 0.028 ↓ 0.0 0 1

Seq Scan on conversion c (cost=0.00..0.00 rows=1 width=40) (actual time=0.027..0.028 rows=0 loops=1)

  • Filter: ((endtime >= 1549443562) AND (endtime <= 1549529962))
6. 19.596 19.596 ↑ 198.9 2,307 1

Index Scan using route_conversion_1549404000_endtime_idx on conversion_1549404000 c_1 (cost=0.42..74,931.74 rows=458,941 width=1,048) (actual time=15.494..19.596 rows=2,307 loops=1)

  • Index Cond: ((endtime >= 1549443562) AND (endtime <= 1549529962))
  • Buffers: shared hit=470 read=10
  • I/O Timings: read=16.795
7. 0.000 0.000 ↓ 0.0 0

Index Scan using route_conversion_1549490400_endtime_idx on conversion_1549490400 c_2 (cost=0.42..46,417.27 rows=284,192 width=1,047) (never executed)

  • Index Cond: ((endtime >= 1549443562) AND (endtime <= 1549529962))
8. 136.113 136.113 ↑ 100.0 1 2,307

Function Scan on jsonb_each esme (cost=0.01..1.00 rows=100 width=0) (actual time=0.058..0.059 rows=1 loops=2,307)

  • Buffers: shared hit=117 read=26
  • I/O Timings: read=111.733