explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ksrW

Settings
# exclusive inclusive rows x rows loops node
1. 0.179 432.442 ↑ 1.0 501 1

Limit (cost=0.57..1,729.47 rows=501 width=68) (actual time=330.133..432.442 rows=501 loops=1)

2. 432.263 432.263 ↑ 418.7 501 1

Index Scan using t_phone2_idt_operator_idx on t_phone2 t (cost=0.57..723,964.92 rows=209,791 width=68) (actual time=330.130..432.263 rows=501 loops=1)

  • Index Cond: (idt_operator = 103)
Planning time : 2,963.575 ms
Execution time : 432.723 ms